Macro button keeps shrinking as it gets used?
I use some buttons that contain macros with visual basic. Each time I press the button, the button works nicely (the macro runs as expected) but the button itself shrinks a bit and keeps shrinking as I keep pressing it eac time. All I want is a button that maintains its original size...
Thanks!
Right-click on the button and select FORMAT CONTROL > PROPERTIES > [x]Do not move and size with cells.
Then set it back the size you want.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Which type of button are you using? The Forms menu buttons or the Controls ToolBox ones.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks