Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Jim,
You are totally correct. That must be the problem; I do have charts.... Let me try your version and post back here. Thanks. Jim Thomlinson wrote: Do you have any chart sheets or such? If so then you will get the error you discussed. Try this to see if it goes any better... Sub ProtectAllSheets() Dim wks As Worksheet Application.ScreenUpdating = False For Each wks In Worksheets With wks .Protect Password:="nosecret" .EnableSelection = xlUnlockedCells End With Next wks 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 |