View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Test whether a chartobject is on a worksheet

Gary was my Excel teacher.

I have never been able to stop objects from moving, but have always relied
on "remembering" where I want them, and then moving back there with Top or
Left.
--
Gary''s Student - gsnu2007g


"Werner Rohrmoser" wrote:

Hi Gary's Student,

thanks, simple and good.
BTW, do you know how the legend and textbox position change on the
chartobject can be avoided.
Because adjusting the shapes is fighting agianst the symptom but not
treating the root cause.

Werner

P.S.: Who is Garry?