Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
![]()
Bard, same as the one Jim posted and I thank both very much for it--it
does work and makes my life easier. Barb Reinhardt wrote: I did tweak it a bit, but didn't have problems where you did. Sub ProtectAllSheets() Dim WS As Worksheet Application.ScreenUpdating = False For Each WS In ThisWorkbook.Worksheets With WS .Protect Password:="nosecret" .EnableSelection = xlUnlockedCells End With Next WS Application.ScreenUpdating = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect and Unprotect all worksheets with macro | Excel Discussion (Misc queries) | |||
400 Error in Unprotect/Protect Macro | Excel Discussion (Misc queries) | |||
Unprotect and protect sheet in a macro | Excel Programming | |||
Protect/Unprotect Sheet from Macro | Excel Programming | |||
Macro to protect and unprotect | Excel Programming |