Using "Protect" Workbook Worksheets across a Workbook
Posted on 2013-01-29
I have a fairly complex Workbook that has a number of different tabs and macros. Whenever a Macro is "fired", I'd like to unlock the specific worksheet (active) and relock after it ends. The problem I have right now is I'm using code to do that with each Macro. It's getting to be unmanagable and I'd like to know if there is a way to have a Workbook Macro that would do the unlock/lock for each WS but only when a Macro is fired and I can control this in one single location within the code. Also, is there a way to turn it off and on without actually going into the code? In other words, have a macro (with a button) that activates the locking function (the universal macro described above).
Thank you in advance.