none
Issue to change cell RRS feed

  • Question

  • Hi,
    I did already unprotect and unlock sheet and cells like

        Worksheets("Ledger").Unprotect Password:="????"
        Worksheets("Ledger").Range("M11:M21").Locked = False
    


    and do not know why it cannot do the change (with below line; Cells(14, 13) is one of the cell unprotected)

                Worksheets("Ledger").Cells(14, 13).Value = Worksheets("Ledger").Cells(14, 13).Value - Worksheets("Ledger").Cells(RowID, 5).Value
    
    



    Many Thanks & Best Regards, Hua Min

    Thursday, April 4, 2019 9:57 AM

All replies

  • The code you have posted works under test.

    Actually, when you unprotect the sheet, there is no need to unlock the cells.

    Is the code returning an error or just not updating the worksheet? If returning an error, what is the error message?


    Regards, OssieMac

    Thursday, April 4, 2019 10:54 AM