locking charts in excel

G

Guest

I am using office 2002, I am trying to lock a chart while still letting users
use a spinner. I cannot do it by protecting the sheet, if I let users edit
objects, they can change the chart. I have unlocked the cells I want them to
use, I just cannot get the spinner to unlock when I want it to. Thank You
 
D

Debra Dalgleish

You could move the chart to a chart sheet, and protect it.
Then, protect the worksheet, and allow changes to objects.

To move the chart, right-click on it, and choose Location.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top