Macro - Playing Macro if cells are locked
 

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

--
Message posted from http://www.ExcelForum.com

Macro - Playing Macro if cells are locked
 

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

--
Regards,
Tom Ogilvy


"sonar " wrote in message
...
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.


---
Message posted from http://www.ExcelForum.com/