Prevent Or Allow Changes To Shapes. Click the Protect Sheet button to Unprotect Sheet when a worksheet is protected. If asked enter your passcode.
Any objects text boxes or shapes on the chart are not protected. I think Ive found what may be the ultimate solution to these problems. Nõustute selle kasutamisega kui jätkate saidi vaatamist.
I could programatically change the button size back but couldnt find a way to change the picture size that way.
The formatting and source data of the chart may be changed. On the Developer tab in the Shape Design group click Protection. You can allow changes to other settings and features the same way you can allow changes to privacy settings. Snap Ensures that shapes align with a grid or other shapes in the drawing.