Command Button & Macro
 

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
--
Tom from Penna

--
Tom from Penna

Command Button & Macro
 

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

Tom schrieb:

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
--
Tom from Penna

--
Tom from Penna

Command Button & Macro
 

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.

"Tom" wrote:

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
--
Tom from Penna

--
Tom from Penna