Skylar
asked on
how to lock some ranges using VBA
how can i lock multiple ranges in sheet2 using VBA
i am using
ThisWorkbook.Worksheets("S heet2").Ce lls.Locked = False
ThisWorkbook.Worksheets("S heet2").Ra nge("B8:C9 ,B5:C6,D1: R1,Q4:R4,A 12:S17,A19 :S33").Loc ked = True
it is not changing the cell to locked. the locked tick mark does not get ticked when i run the above code. i do not know why
i am using
ThisWorkbook.Worksheets("S
ThisWorkbook.Worksheets("S
it is not changing the cell to locked. the locked tick mark does not get ticked when i run the above code. i do not know why
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER