Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to create a toggle button that will unprotect and then protect
all worksheets, while allowing users to select unlocked cells. I tried cobbling a few codes I found together but it isn't working. Below is the code. Can someone help me with a code (hopefully one that isn't too complicated). Thanks Kellascat Private Sub ToggleButton1_Click() With ToggleButton1 If ToggleButton1.Caption = "Unprotected" Then For Each ws In Worksheets ActiveSheet.EnableSelection = xlUnlockedCells ws.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, _ Password:="PDC", UserInterfaceOnly:=True Next ws Else ToggleButton1.Caption = "protected" For Each ws In Worksheets ws.Unprotect Password:="PDC" Next ws End If End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect/unprotect ALL worksheets in workbook ? | Excel Discussion (Misc queries) | |||
How to protect and unprotect multiple worksheets effeciently | Excel Discussion (Misc queries) | |||
Protect/Unprotect Multiple Worksheets | Excel Discussion (Misc queries) | |||
unprotect/protect grouped worksheets in excel | Setting up and Configuration of Excel | |||
Protect/unprotect all worksheets | Excel Worksheet Functions |