I have a shared worksheet that I have password protected so no one can change
formulas in the cells. I would like to set up macros to provide me with a
certain view for printing and research. Everytime I set up the macro and
protect the sheet it says that I can not use the macro.

Is there anyway around this or will I have to unprotect the sheet everytime
I want to use the macro? Any ideas or suggestions would be greatly
appreciated. Thank you.