Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mass Protect and unProtect
Is there some code that will protect and some more code that will Unprotect
all spreadsheets in a workbook? I thought something like this would work if I named all the sheets, but it doesn't! Copied from Help and change Select to Protect.........Worksheets(Array("Sheet1", "Sheet2", "Sheet4")).Protect What's wrong with this code? ("Says subscript out of range") All those sheets exist. In fact this won't even work on 1 sheet! However, I'd rather some code that did all the sheets, even if I added others. Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect/ unprotect worksheet | Excel Discussion (Misc queries) | |||
Protect-Unprotect all the sheets | Excel Worksheet Functions | |||
Protect/Unprotect Worksheet | Excel Discussion (Misc queries) | |||
Is there any way that you can protect or unprotect a group of wor. | Excel Discussion (Misc queries) | |||
Protect/unprotect all worksheets | Excel Worksheet Functions |