98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » excel+courses - Command button caption font size
excel+courses - Command button caption font size
Resolved · Low Priority · Version Standard
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
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlinesExcel 2010 allows you to change the colour of grid lines instead of keeping them in boring black. |