Working with Charts(unlocked) in protected worksheet

[nagovind]

I have a XY scatter chart
Properties Locked = Unticked
Worksheet protected with a password
While running the VBA if we try to change the chart properties through VBA, we need to unprotect sheet by supplying password inside the VBA to do the changes in the Chart then after again protecting the sheet in VBA
This process is time consuming and shows more delay

How to work with chart properties in protected worksheet through VBA

 

[vletm]

Have nagovind tested below?

Allow selecting but not editing a chart and slicers in a protected Excel sheet

I would like to share an excel file that has slicers and charts in it. I want users to be able to use the slicers for filtering and then select and copy the charts. But I want to protect the sheet ...

superuser.com

 

[nagovind]

@vletm
Is this the one?

For Each i In ActiveSheet.ChartObjects
i.Chart.ProtectSelection = False
i.Chart.ProtectData = True
i.Chart.ProtectFormatting = True
Next i

 

[vletm]

nagovind
I asked question from You...
I cannot know
have You tested something
if You won't answer.

Many things depends of settings and what will You do, especially while use protection.