ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Enlarging Command Buttons (https://www.excelbanter.com/excel-discussion-misc-queries/264647-enlarging-command-buttons.html)

RussellT

Enlarging Command Buttons
 
I have a number of Command Buttons embedded on Worksheets. For some reason
some of them tend to grow in size upon usage to the point that after a while
they fill the entire screen. What's going on?

Dave Peterson

Enlarging Command Buttons
 
I don't think anyone knows.

Sometimes, you can delete the old commandbutton and replace it with a new
commandbutton (and change the name so the macro will still work!).

Personally, I've never seen this happen. But lots of people have.

I like to use buttons from the Forms toolbar with the macros located in a
General module -- and assigned to that forms button.

I very rarely use the commandbutton from the control toolbox toolbar.

RussellT wrote:

I have a number of Command Buttons embedded on Worksheets. For some reason
some of them tend to grow in size upon usage to the point that after a while
they fill the entire screen. What's going on?


--

Dave Peterson

Don Guillett[_2_]

Enlarging Command Buttons
 
I never use those. Usually use shapes..

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dave Peterson" wrote in message
...
I don't think anyone knows.

Sometimes, you can delete the old commandbutton and replace it with a new
commandbutton (and change the name so the macro will still work!).

Personally, I've never seen this happen. But lots of people have.

I like to use buttons from the Forms toolbar with the macros located in a
General module -- and assigned to that forms button.

I very rarely use the commandbutton from the control toolbox toolbar.

RussellT wrote:

I have a number of Command Buttons embedded on Worksheets. For some
reason
some of them tend to grow in size upon usage to the point that after a
while
they fill the entire screen. What's going on?


--

Dave Peterson




All times are GMT +1. The time now is 06:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com