Locking Objects

[Zach]

I am having some difficulties with added objects, lines and text boxes,
shifting position on a chart when I email the sheet from within Excel 2000.
Every object seems to shift to the right in the emailed copy. I must be
missing something simple but still have not found the solution.

 

[Jon Peltier]

Just emailing the chart? How about emailing a picture of the chart. In
VBA you can use the command:

ActiveChart.Export ChartPathAndFileName.gif, "GIF"

If you don't want to use VBA, John Walkenbach's Chart Tools is a free
addin that does this, and more neat tricks. It's at http://j-walk.com.

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

 

[Zach]

Jon,

Thanks. I have John Walkenback's Chart Tools and never even gave it a
thought!

I am still wondering why the shift occurs for no apparent reason but will
use "Chart Tools" until I find the answer.

Thanks Again,

Zach