View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default 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,