Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If I have a work sheet protected and try to run a macro to hide rows or columns it won't work. Correct?
Marc
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to update a column in a work based on another work sheet | New Users to Excel | |||
2007 excel work sheet will not allow to insert rows or columns | Excel Discussion (Misc queries) | |||
protected work sheet | Excel Discussion (Misc queries) | |||
Protected work sheet | Excel Discussion (Misc queries) | |||
Macro protected work sheet | Excel Programming |