I have the following code:
From a separate module, when I call each sub sequentially, I get my chart and legend to the left and incorrectly sized.
Please Login or Register to view this content.
If, however, I utilize breakpoints, or simply place my cursor in each sub (again sequentially), I get the intended results.
Anyone have an idea what is going on here?
Last edited by Kaziglu Bey; 05-21-2012 at 02:58 PM. Reason: found a solution
I have figured this out. I'll post should anyone come across this.
The above three sub routines are called from another sub routine and are nested between ScreenUpdating. When the chart object is created, it is done so with a default position and size. The legend and pie chart positions, and size, seem to be set with the default chart object position and size, so when ScreenUpdating is set to true, only the chart object gets the intended property changes.
Hope that helps someone else.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks