Locking Chart Area


J

Juan

Hi,
If i insert a chart sheet into an excel workbook I get a Chart sheet and on
top of it is a Chart Area that can be moved and resized. My Question is how
do I lock the Chart Area from being moved or resized? I've tried setting the
locked property on the Chart Area, Protecting the workbook, through the
interface and through VBA with no luck. What am i missing here?

Thanks,
 
Ad

Advertisements

S

ShaneDevenshire

Hi,

Assuming you are in 2003 or earlier, when you choose Tools, Protection,
Protect Sheet, make sure to uncheck Edit Objects before you click OK.
 
J

Juan

Thank you for your reply and my apologies I am using Excel 2007. I'm looking
to stop the Chart Area from being moved or resized and not concerned about
being able to edit it or delete it.

Thanks!
 
M

Mary

I have the same problem in a workbook with probably 50 chart worksheets. I
have to recenter every chart. I'm also using Excel 2007. Would love to hear
some solutions, too.
Thanks.
 
F

FlyingCub

When you go to protect the sheet, scroll down in the options area and uncheck
the Edit Objects box. Then type in your password to protect the sheet.
 
Ad

Advertisements

M

mike

I tried this and it is not working.

FlyingCub said:
When you go to protect the sheet, scroll down in the options area and uncheck
the Edit Objects box. Then type in your password to protect the sheet.
 
Ad

Advertisements


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