Daniel has attended:
Excel VBA Intro Intermediate course
Command button caption font size
I have a problem where all the command buttons in a workbook, when clicked, reduce the size of the caption. If I go into properties, the font size has not changed. Every time you click the button it shrinks again until you cannot view the text at all.
Any suggestions?
RE: command button caption font size
Hi Daniel,
Thankyou for your question
There are a number of possibilities here.
First, does the spreadsheet alter the size of rows or columns when you click the button? This can sometimes effect the size of the button. If you right click on the button and select formatbutton, and then button properties you will find a couple of options that allow you to tell excel not to shrink the button with cells.
If this is not the solution, you might have some unforseen consequence which is automatically altering the size of the button. If you wish, I'd be happy to look at the problem. If so please email the spreadsheet to
infoATmicrosofttrainingDOTnet and mark it for the attention of stephen
Regards
Stephen
RE: command button caption font size
Hi Stephen
When I closed and reopened the workbook, the buttons now work correctly so I just had to manually delete and recreate the buttons.
It must have been an unforseen consequence as you say above, but it was not changing the size of the button, just the text on the button.
A bizarre problem which appears to have resolved itself.
Thanks
Dan
