|
Fixed Chart Location
How can I place a chart on a worksheet so that it cannot be moved around?
Thanks in advance for any help. -- Dave_DD |
Fixed Chart Location
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 |
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 |
| All times are GMT +1. The time now is 04:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com