Scaling a chart from vba on a Protected Sheet

[spurs]

Is it necessary to unprotect a worksheet containing a chart in order to have VBA code rescale the chart? I am trying to force a scale change using VBA code and I find that it only works if the chart is unprotected.


Is there a workaround without needing to unprotect and protect the sheet after every calculation

 

[spurs]

bump

 

[AlphaFrog]

Set the DrawingObjects argument to False e.g.

ActiveSheet.Protect DrawingObjects:=False

This will allow you to edit the chart while the sheet is protected.

 

[spurs]

AlphaFrog
With this code entered, I now get prompted for a worksheet password for the chart worksheet/ This defeats the purpose of what I am looking to do.

Anyone have another suggestion?