Bright01
asked on
Adding Protection to a Workbook by Spreadsheet with a Global command
EE Pros,
I have a workbook that has a number of Worksheets that need to have protection on and off and on again. The reason for this is that I need to protect the worksheets against users making changes and at the same time, I have a number of macros and outline layers that if I have protection on, it generates an error when it tries to fire the macro.
Here's my question; is there a macro or a way to put a short macro in a module that will turn protection on or off automatically based on a macro firing? Even when I expand and contract an outline, I'm doing it with a macro (not the traditional way of selecting 1, 2, etc.).
Thank you in advance,
B.
I have a workbook that has a number of Worksheets that need to have protection on and off and on again. The reason for this is that I need to protect the worksheets against users making changes and at the same time, I have a number of macros and outline layers that if I have protection on, it generates an error when it tries to fire the macro.
Here's my question; is there a macro or a way to put a short macro in a module that will turn protection on or off automatically based on a macro firing? Even when I expand and contract an outline, I'm doing it with a macro (not the traditional way of selecting 1, 2, etc.).
Thank you in advance,
B.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hope you are having a good time in SF.
B.