View Full Version : Protecting a chart but allowing chart data to change?


scott-atkinson
09-07-2007, 06:57 AM
Guys,

I have another issue.

I have a chart with macro buttons on which toggle between data that the chart presents.

How can i protect the sheet so the user cannot delete the buttons or chart but allow the chart to toggle the data?

unmarkedhelicopter
09-07-2007, 07:11 AM
Post example sheet

scott-atkinson
09-07-2007, 07:18 AM
Post example sheet

Chart.

Attached is a screen shot of my chart, I want to be able to protect the chart and buttons from being deleted but allow the data to be toggled.