Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I currently have a macro which allows me to protect/unprotect multiple
wortksheets. However, how do I expand the code to apply all the protection options when protecting? I keep receiving errors when manipulating the code after referencing it from the macro recorder. My current code is as follows: Sub ProtectAllSheets() Application.ScreenUpdating = False Dim N As Single For N = 1 To Sheets.Count Sheets(N).Protect Password:="password" Next N Application.ScreenUpdating = True End Sub Sub UnprotectAllSheets() Application.ScreenUpdating = False Dim N As Single For N = 1 To Sheets.Count Sheets(N).Unprotect Password:="password" Next N Application.ScreenUpdating = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect/unprotect all sheets at once? | New Users to Excel | |||
Protect-Unprotect all the sheets | Excel Worksheet Functions | |||
How to protect and unprotect multiple worksheets effeciently | Excel Discussion (Misc queries) | |||
Protect/Unprotect Multiple Worksheets | Excel Discussion (Misc queries) | |||
Macros for Protect/Unprotect all sheets in a workbook | Excel Discussion (Misc queries) |