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

Marc

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

Hi Marc,

Try:

Activesheet.Unprotect

'Your code

Activesheet.Protect


---
Regards,
Norman



"Marc" wrote in message
nk.net...
Marc

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

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" wrote in message nk.net...
Marc