Command Button & Macro

[Guest]

In my Excell Spread Sheet I use a command Button to run a Macro to reset my
Spread sheet to default settings (in Cells). Ocasionally when I click the
Button it gets larger each time I click it. I have to close the spread sheet
and reopen it to fix this problem. Does anyone have any suggestions on this
issue???? This probl;em does not always happen and this spread sheet is
used on a network and the same issue occurs on other work stations.

Thanks

 

[Udo]

Hi Tom,

sounds really strange. Have you already had a look at other events
associated with that button, e.g. DblClick, GotFocus, MouseMove?
Perhaps there is also some code, not unly with Click.

Good luck
Udo

 

[Guest]

Chect the properties for the command button to see if you have AutoSize =
True. If you do, change it to False and see if you still get the same
effects.