View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Dave_AD Dave_AD is offline
external usenet poster
 
Posts: 8
Default Fixed Chart Location

Jon,
Thanks for the help. It was simply a case of unprotecting the cells I want
the user to change, but keeping the chart locked, then turning the sheet
protection on. That way the chart can't be select and moved.

--
Dave_DD


"Jon Peltier" wrote:

You can protect it against user selection:

http://peltiertech.com/Excel/ChartsH...rotection.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Dave_AD" wrote in message
...
How can I place a chart on a worksheet so that it cannot be moved around?
Thanks in advance for any help.
--
Dave_DD