excel+courses - command button caption font

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum 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

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

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 gridlines

Excel 2010 allows you to change the colour of grid lines instead of keeping them in boring black.

Select the File tab on the Ribbon, click Options, click Advanced, scroll down to ''Display options for this worksheet.'' Next to ''Gridline colour,'' choose your favourite colour, then once you've done this, click OK. Easy!

View all Excel hints and tips


Server loaded in 0.07 secs.