Non-selectable object

[wwbwb]

Is it possible, and if so, how can I make an object, specificly a chart on a sheet, not selectable. I have a macro that selects the chart on the page, deletes it, then makes a new chart with the new data. What I need is to have the chart not selectable by the user. Any ideas?

 

[wwbwb]

 

[Tom Urtis]

Right click on the chart, choose Format Chart Area > Properties tab, and select (put a check mark next to) Locked. Click OK.
From the worksheet menu, click on Tools > Protection > Protect sheet, set your protection options and password (if any), and click OK.

 

[wwbwb]

thanks.