We help IT Professionals succeed at work.

how to unlock all cells of sheet("data") via VBA?

Flora Edwards
on
i am using below code but it does not work.

ThisWorkbook.Worksheets("Data").Cells.Locked = False

Open in new window

Comment
Watch Question

Top Expert 2016
Commented:
Hi,

is the sheet already protected?

Regards
Flora EdwardsMedicine

Author

Commented:
No it is not
Top Expert 2016

Commented:
pls send a dummy
Flora EdwardsMedicine

Author

Commented:
thank you. you nailed it.

it was protected.