Macros enable

[saracat1]

I am trying to find a way to enable macros in a protected sheet. I have several Excel worksheets that I send out every week. They now have macros incorporated into them, with three buttons, so you are able to view only the specific sections you want by pressing a button. The only problem is when I protect the worksheet, the macros is disabled. I can allow Auto format in the protection box, but I do not see anything to do with macros. Please help.

 

[carsten]

Does these macros e.g. hide/unhide rows or columns?

 

[saracat1]

Yes they do.

 

[lenze]

You will have to unprotect the sheets (with code) to run the macros

Sub Fanugi()
Activesheet.Unprotect "password"
'Your code
ActiveSheet.Protect "password"
End Sub

lenze