nagovind
Member
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
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