Sheet Protection

[DejaVu]

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?

[Leith Ross]

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

[DejaVu]

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