Macro - Playing Macro if cells are locked

S

sonar

Hi

I want to create a macro to hide and unhide certain columns with "F
keys.

Will it work when most of my cells are locked and password protected?

Thanks
 
T

Tom Ogilvy

Sub MyMacro()
ActiveSheet.Unprotect Password:="ABCD"
' recorded code
Activesheet.Protect Password:="ABCD"
End Sub
 
Top