Re-protecting a spreadsheet Macro
Posted on 2011-09-05
I have a worksheet that I have protected. I periodically give users the password in order for them to make changes. When they click on one of the buttons on the worksheet, I want the spreadsheet to password enable the spreadsheet again.
I have this macro embedded in the button that takes a user back to another worksheet and that's where I wanted to call this macro.
I thought this to be a simple one.
Thank you in advance.