Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » excel+courses - Command button caption font size
|
|
|
Bookmark this page|
The UK's most regular 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+courses - Command button caption font size
Resolved · Low Priority · Version Standard
Reply
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?
For upcoming training course dates see: Pricing & availability
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 StephenWhen 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
|
 |
How To Protect Your Work In Excel 2010 We live in an increasingly security-conscious world, and never more so than when it comes to data. If you have to protect your work in Excel 2010, here are some ways you can go about it. » Article: Excel training london |
» Forum post: Styles and Formatting |
» Tip: Selecting different days |
Overall information.
This works best in the 1 day view and is using the date Navigator.
