| 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 | |||
Linear Mode
