I have a very large WB with about 8 WSs that have a system of turning on and off Protection to help guide a user of the WB. I have also built a Admin. Tab that allows for someone to do some administrative modifications to the WS's if they like. Here is my question;
Do you have or can we create a short macro, that when fired will disable Protection throughout the WB? Then when fired again, will turn protection back on and adhere to the countless references of ProtectOn or ProtectOFF that I have in my WSs throughout my WB? This way, I never really have to give out a password and at the same time, the Admin. or person wanting to modify a WS, can easily disable Password protection at the WS level. This should not interfere with the Developer Protection for the WB for changing macros.
That's it! Thank you in advance,