Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Locking Chart Area
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, |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Locking Chart Area
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. -- Thanks, Shane Devenshire "Juan" wrote: 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, |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Locking Chart Area
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! "ShaneDevenshire" wrote: 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. -- Thanks, Shane Devenshire "Juan" wrote: 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, |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Locking Chart Area
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. -- Mary B. "Juan" wrote: 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! "ShaneDevenshire" wrote: 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. -- Thanks, Shane Devenshire "Juan" wrote: 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, |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Locking Chart Area
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. "Mary" wrote: 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. -- Mary B. "Juan" wrote: 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! "ShaneDevenshire" wrote: 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. -- Thanks, Shane Devenshire "Juan" wrote: 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, |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Locking Chart Area
I tried this and it is not working.
"FlyingCub" wrote: 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. "Mary" wrote: 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. -- Mary B. "Juan" wrote: 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! "ShaneDevenshire" wrote: 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. -- Thanks, Shane Devenshire "Juan" wrote: 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you show plot area only-no chart area | Charts and Charting in Excel | |||
Stacked area and area chart combo | Charts and Charting in Excel | |||
Resize plot area in a chart area | Excel Discussion (Misc queries) | |||
How to increase chart area without affecting plot area? | Charts and Charting in Excel | |||
Resize chart area without resizing plot area | Charts and Charting in Excel |