delete button on pie chart

[roberta93536]

On one of my worksheets I have a button that creates a pie chart. I want the option to delete the pie chart after I've reviewed it. I am using the macro recording feature to create the pie chart with the delete button, this seems to work OK. Then I delete the pie chart (with the button). When I test the chart creation process the button (& macro) change location/size. It seems to be reduced to the fartherest upper left corner of the chart, it's not really even visible, just a dot. I could put the delete button on another worksheet I suppose, but I would prefer to keep it on the same worksheet as the pie chart if at all possible. Any suggestions why this is happening or what I might do to resolve the problem would be greatly appreciated.

[Jay Petrulis]

On 2002-05-15 16:54, roberta93536 wrote:
On one of my worksheets I have a button that creates a pie chart. I want the option to delete the pie chart after I've reviewed it. I am using the macro recording feature to create the pie chart with the delete button, this seems to work OK. Then I delete the pie chart (with the button). When I test the chart creation process the button (& macro) change location/size. It seems to be reduced to the fartherest upper left corner of the chart, it's not really even visible, just a dot. I could put the delete button on another worksheet I suppose, but I would prefer to keep it on the same worksheet as the pie chart if at all possible. Any suggestions why this is happening or what I might do to resolve the problem would be greatly appreciated.

Hi,

Please post your code to get an exact solution (we hope! ).

You should be able to anchor the postion and size when it is created, and also set the properties/positioning. A few more details are needed, though.

Regards,
Jay