View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default 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