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?
|