Running a MACRO on a protected Excel tab

[Northern NY Design]

I have created buttons with attached MACROs to show each day of the week in a report based on which day I click. The problem I have is that I have each tab in the spreadsheet locked and when I try to run the MACROs with the tab locked, it gives me an error. What permissions do I need to click on or off when I protect the tab to allow the MACRO to run on a prtected tab?

Thank you.

 

[Joe4]

You cannot run code against protected worksheets.
What you would typically do is add code to the top of your procedure to first unprotect the tab, make your changes to it, and the re-protect it.

See here for examples of how to do this: Protect and Unprotect Sheet Using VBA

 

[Northern NY Design]

You cannot run code against protected worksheets.
What you would typically do is add code to the top of your procedure to first unprotect the tab, make your changes to it, and the re-protect it.

See here for examples of how to do this: Protect and Unprotect Sheet Using VBA

 

[Northern NY Design]

Well ****; that just don't float my boat. Thanks :D

 

[Joe4]

You are welcome.
Glad I was able to help!