Moving Objects

[icetrey]

I have a picture and an object (Line) that I have placed on top of
chart area. After I do work on other sheets in the workbook and retur
to the sheet with the objects, they sometimes move slightly from where
placed them. How can I get them to stay put. I have tried to lock an
protect them, but they still move. Not everytime, but often

 

[Norman Jones]

Hi Icetrey,

See MSKB Article # 838910 (Controls move to the left of the worksheet in
Microsoft Excel 2002) :

http://support.microsoft.com/default.aspx?scid=kb;EN-US;838910


See also the final contribution (from Bob Phillips) in the following thread:

http://tinyurl.com/co6ae

 

[mangesh_yadav]

One way is to set the top and left positions in the VBA and then run it
on the Activate event of your chart.

Mangesh

 

[icetrey]

Thanks, the problem seems to be fixed.