• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Unprotect sheet but Keep buttons Protected

TravisF

New Member
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
 
See first the options when you manually protect the worksheet.​
If you do not find manually a way then there is no solution …​
 
Better way discovered. Instead of unprotect....just unlock any cells that to be edited, relock when done.
Keeping protect on. kinda duh I guess!
 
Back
Top