If I have a work sheet protected and try to run a macro to hide rows or columns it won't work. Correct?

Marc

Hi Marc,

Try:

Activesheet.Unprotect

'Your code

Activesheet.Protect


---
Regards,
Norman



"Marc" <mcnr(N_O-S_P_A_M)@mindspring.com> wrote in message
news:qqZsg.3424$vO.1052@newsread4.news.pas.earthlink.net...
> Marc
>
>

I believe you are correct, but there are other options.

Take for instance... you can have your macro unprotect your sheet - run your macro - and then reprotect your sheet.

Sub MyMacro()
Dim Password 'This line of code is optional
Password = "1234"
ActiveSheet.Unprotect Password

~~ Your macro code goes here ~~

ActiveSheet.Protect Password, True, True, True
End Sub

--
Mark Ivey
"Marc" <mcnr(N_O-S_P_A_M)@mindspring.com> wrote in message news:qqZsg.3424$vO.1052@newsread4.news.pas.earthlink.net...
Marc