Macros and Sheet Protection Criteria

[Excel for President]

Currently, my excel has multiple macros that are linked to buttons and another excel embedded. The only purpose of the buttons are to hide/unhide rows. Right now, when I protect my sheet, I check mark the boxes labeled "Select unlocked cells" and "Edit Objects". My macros are set to unlock the sheet before performing their action and then lock again. However, after it locks, the only box checked in the protection criteria is "Select unlocked cells" which renders the embedded excel useless because I can no longer edit objects. I confirmed this by un-protecting and re-protecting the sheet manually. Does anyone know of a way to fix this? All help is greatly appreciated!

 

[svendiamond]

Try

Sheets.Protect DrawingObjects:=False

 

[Logit]

Kinda difficult to understand what you are asking ... but ... if you mean "I want to protect the Sheet but allow certain cells to be unprotected so they can still function / be edited " ...

Look at this resource from M$ :

https://support.office.com/en-us/ar...orksheet-75481b72-db8a-4267-8c43-042a5f2cd93a


If you are asking something else, you'll have to be clearer. Sorry.

 

[Excel for President]

Try

Sheets.Protect DrawingObjects:=False

This worked perfect! Thank you everyone who posted!