Sorry if this is repeated. May not have gone thru first time
Have a toggle button to protect/unprotect sheet. This works fine.
When Unprotected, would like to keep the buttons Protected.
Would like to do this,but it doesnt work. No option like this.
sht.Unprotect Password:="123", DrawingObjects:=True
Tried doing this thinking it would only do DrawingObject protect..but it reprotects the whole sheet again. Guess that makes sense
sht.Unprotect "123"
then adding line
shSelector.Protect DrawingObjects:=True
How can one do Unprotect while keeping buttons protected. Is older excel ver 2007
Have a toggle button to protect/unprotect sheet. This works fine.
When Unprotected, would like to keep the buttons Protected.
Would like to do this,but it doesnt work. No option like this.
sht.Unprotect Password:="123", DrawingObjects:=True
Tried doing this thinking it would only do DrawingObject protect..but it reprotects the whole sheet again. Guess that makes sense
sht.Unprotect "123"
then adding line
shSelector.Protect DrawingObjects:=True
How can one do Unprotect while keeping buttons protected. Is older excel ver 2007