Here is the situation

I have a spreadheet that cycles monthly data.
Each sheet is a new month and 12 are kept in the book
I have a macro that copies information from each sheet to the next showing the last quarter of context for each sheet
Of course only the new quarter's information is editable or should be
So I need to have my macro copy protected information
If the protection is not passworded then I can turn it off, copy, and turn it on
But all the users know this as well and they turn off the protection and ruin the formulas, etc
Further if I password protect it then copying protected cells requires password entry which dosent work because I do not want the users to have the password.
So I need a way to BYPASS the password protection that works for the macro. Id there one