Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
worksheet protection
is there any simple way to protect or unprotect multiple worksheets at once?
-- joec |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
worksheet protection
two macro's
protect and unprotect Sub protect() For Each sheet In Sheets On Error Resume Next sheet.Protect ("yourword") Next ActiveWorkbook.Protect ("yourword") Application.StatusBar = "" End Sub Sub unprotect() ActiveWorkbook.Unprotect ("yourword") For Each sheet In Sheets On Error Resume Next sheet.Unprotect ("yourword") Next Application.StatusBar = "NOT sealed" End Sub Application.StatusBar = "NOT sealed" this line indicates in the statusbar at the bottom of the excel window whether the sheet is protected or not when you install the macro link it to a shortcut key combination -- Greetings from New Zealand "joec" wrote in message ... is there any simple way to protect or unprotect multiple worksheets at once? -- joec |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Protection | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
Worksheet Protection | Excel Discussion (Misc queries) | |||
worksheet protection | Excel Worksheet Functions |