Button font changes

[SteveO250k]

I'm using Excel 2003. I placed two buttons on a blank sheet. I called them
cmdOne and cmdTwo. The captions are New and Report respectively. There are
no macros in this spreadsheet and nothing (that I know of ) attached to their
click events. When I alternate clicking the buttons, the font grows larger.
When I look at the font properties, the font size does not change. If I
resize the buttons, the caption font assumes it's attribute setting.

What's is going on?

 

[Dave Peterson]

You could delete them and re-add them. Sometimes that works.

Or you could delete them and add buttons from the Forms toolbar. They behave
better, but they don't have as many features that you can fiddle with.

As a curiousity, why have the commandbuttons/buttons if there is no code? Maybe
hyperlinks???

You may want to use different shapes (from the Drawing toolbar) if you want
prettier objects.

 

[SteveO250k]

Dave,

Thanks for your quick response.

I actually have the problem in another spreadsheet which does something. In
an effort to troubleshoot the problem I created a blank workbook and added
just the buttons.

Troubleshooting further, I closed all workbooks except the blank one with
the two buttons and the problem went away. When I re-open the original
workbook the problem reappears in both workbooks. Some VBA or macro in the
original workbook is kidnapping any button on any worksheet and changing the
font size. (althought the sheet1.cmdOne.font.size attribute does NOT change).

In the original workbook the click event for each button calls a routine to
start what ever (add a new record or run a report). I commented out that
call so the click event does nothing, no code is called. The font size still
changes when I alternate clicking between the buttons.

My next step is to comment out each subroutine until the problem goes away.

 

[Dave Peterson]

I don't think you'll find any code that's changing the font size. I'd bet that
it's just misbehaving controls. You can search google and you'll find that this
happens to other people, too.

It's not common (I don't recall seeing it in real life, but I like buttons from
the Forms toolbar), but it shows up in the newsgroups every so often.

 

[SteveO250k]

Thanks, I switched to the forms buttons and the problem went away.
Microsoft, can't live with them, can't live without them. 8^)

Thanks for your help,

Steve O

 

[Dave Peterson]

Sometimes, deleting them and re-adding them can stop/delay the problem.

Thanks, I switched to the forms buttons and the problem went away.
Microsoft, can't live with them, can't live without them. 8^)

Thanks for your help,

Steve O