Is there a tag I can put in at the beginning of a macro that will turn off Sheet Protection, then a tag at the end to turn it back on?
Is there a tag I can put in at the beginning of a macro that will turn off Sheet Protection, then a tag at the end to turn it back on?
Hello Dejavu,
Here is the code to simply turn protection on and off without a password ...
Worksheets("Sheet1").Protect
Worksheets("Sheet1").UnProtect
Substitute your worksheet name for Sheet1 in the example.
Sincerely,
Leith Ross
Thank you Leith, that was exactly what I needed. I knew it would be simple, but I was running into a brick wall yesterday. I should have just stepped away for a while, then came back to it.
Thanks again for your help,
DejaVu
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks