Protected Sheet Allow Edit Objects

[jonhfl]

Hi all,

I have a sheet that I protect on workbook open with the following:

Please Login or Register  to view this content.

I would also like to have Edit of Objects enabled however I am running into errors whenever I add that.

Any thoughts?

Thank you,
Jon

[exceloy]

Hello Jon.
In a similar case I have a protected sheet with a lot of numerical data and with a shape floating above. When I protect the sheet I select the option Modify Objects that allows me to change the text header in the shape, without touching the data. It´s equivalent in code (if I record a macro) is

DrawingObjects:=False

So your code will be:

Private Sub Workbook_Open()

With Worksheets("Template")
.EnableOutlining = True
.EnableAutoFilter = True
.Protect Password:="", _
Contents:=True, DrawingObjects:=False, UserInterfaceOnly:=True, _
AllowFormattingCells:=True
End With
End Sub

I´m not sure if this will be of any help for your purpose.

Eloy

[jonhfl]

Thank you. That got me past my first issue. Now I am needing to exclude the Charts and Chart objects as I have a macro that runs that updates the colors of specific series and is failing when the sheet is protected.

I tried to add

Please Login or Register  to view this content.

where I added the DrawingObjects but that did not work.

Any thoughts?

Thank you.

[romperstomper]

You cannot exclude certain types of objects. It's all or nothing, I'm afraid.