Macros not functioning due to protected sheet

[nathans excel]

Good day, created a fine looking spread sheet loaded with functionality ... one of them being some command buttons which reveal some hidden rows upon each "click" ... locked all the cells I didn't want people to mess around with and protected the sheet ...

in "protected sheet" mode the button and macros are unresponsive and yields ... runtime error 1004 .. .unable to set the hidden property of the range class

when the sheet is unprotected ... works like it is supposed to.

So the conclusion is the protection has it locked down ...

is there some code I can add to the "worksheet" to let the macros/button functionality still do its job?

Nathan
Excel 2013

 

[philwojo]

Maybe try this:

Example to Protect Worksheet

[COLOR=#00A0C8][FONT=inherit]Sub sbProtectSheet()
[/FONT][/COLOR]ActiveSheet.Protect "password", True, True 
[COLOR=#00A0C8][FONT=inherit]End Sub[/FONT][/COLOR]

Example to UnProtect Worksheet

[COLOR=#00A0C8][FONT=inherit]Sub sbUnProtectSheet()
[/FONT][/COLOR]ActiveSheet.Unprotect "password"
 [COLOR=#00A0C8][FONT=inherit]End Sub[/FONT][/COLOR]

 

[mrshl9898]

Can you just turn off and then on the protection at the start and end of the macro?

[COLOR=#333333][FONT=Courier]sheet("yoursheetname").Unprotect Password:="yourPassword"

'your code here

[/FONT][/COLOR][COLOR=#333333][FONT=Courier]sheet("yoursheetname").Protect Password:="yourPassword"[/FONT][/COLOR][COLOR=#333333][FONT=Courier]
[/FONT][/COLOR]