macro error message

[jtblackburn]

First, I am a newbie when it comes to VBA so I apologize if this is really simple...

I created a simple macro button to hide certain columns. I have two reports on one worksheet and want users to be able to switch between the two without scrolling. My solution was to create a button to hide the first report. The second report needs to have the cells password protected so users do not edit the formulas. The macro works fine but when I try to open the file I get the following error:

"That command cannot be performed while a protected sheet contains another pivottable report based on the same source data.

To remove protection from the sheet that has the other report, click the sheet tab, and then click Unprotect Sheet. Then try the command again."

How can I prevent this so users don't have to see this error every time they open the file?

 

[jtblackburn]

After researching, I think what I'm looking for is a script that Excel will run right when the file opens to unprotect then protect the file to avoid the error message.