Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I protect a range of worksheets in a book with one action?
If a workbook contains, say 20 worksheets, is there a way of
protecting/unprotecting all the sheets at the same time to avoid going into each one separately to protect? Using Office Excel 2003. |
#2
|
|||
|
|||
No I don't think so unless you create a macro.
-- Regards, Martin "Sussex Fran" wrote: If a workbook contains, say 20 worksheets, is there a way of protecting/unprotecting all the sheets at the same time to avoid going into each one separately to protect? Using Office Excel 2003. |
#3
|
|||
|
|||
Use these 2 macros to protect and unprotect all sheets:
Sub ProtectAllSheets() Dim ws As Worksheet Dim strPassWord As String strPassWord = "apple" '<--- set password here For Each ws In ThisWorkbook.Worksheets ws.Protect Password:=strPassWord Next End Sub Sub UnprotectAllSheets() Dim ws As Worksheet Dim strPassWord As String strPassWord = "apple" '<--- set password here For Each ws In ThisWorkbook.Worksheets ws.Unprotect Password:=strPassWord Next End Sub --- Put the code in a regular/standard module. If you've never worked with macros before, see: http://office.microsoft.com/en-us/as...047111033.aspx and http://www.mcgimpsey.com/excel/modules.html HTH Jason Atlanta, GA "Sussex Fran" wrote: If a workbook contains, say 20 worksheets, is there a way of protecting/unprotecting all the sheets at the same time to avoid going into each one separately to protect? Using Office Excel 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set print range for a number of worksheets | Excel Discussion (Misc queries) | |||
Moving worksheets in a book | Excel Worksheet Functions | |||
How to protect and unprotect 30 worksheets in a file every month . | Excel Worksheet Functions | |||
Macro with Range of Worksheets | New Users to Excel | |||
SUMIF across a range of worksheets | Excel Worksheet Functions |