Adding Protection to a Workbook by Spreadsheet with a Global command
Posted on 2014-11-01
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,