Forum Discussion
Excel - Form control staying locked when worksheet protected
Hi There, I have a spreadsheet with a Form Control spin button. When I protect the worksheet, the spin button stays locked even though I unticked the "Locked" option in the format control. I do have...
Add password unlock at the beginning of the macro and password protection at the end.
See the VBA example.
sub macro()
Worksheets("sheet name").unprotect Password:="test"
your macro statement
Worksheets("sheet name").Protect Password:="test"
end sub
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful!
This will help all forum participants.