Command Buttons on Excel Worksheet - font size decreases on click

[Guest]

Hi,

We're are enountering a strange problem. We have a spreadsheet with a lot
of CommandButtons that fire different pieces of VBA code in the spreadsheet.

This works fine on the developer PC, but when rolled out to a production PC
we see a strange error happen. Sometimes - not all the time - after clicking
on the button the font of the button caption reduces in size. This happens
until the font is so small that the user cannot read the button text.

Earlier this year someone else encountered this "Problems with Command
Buttons Randomly Resizing themselves"
http://msdn.microsoft.com/newsgroup...3452c0-a331-4a36-a173-3ccb93c7b303&sloc=en-us

The production PC is a high end twin processor HP workstation running Excel
2002 SP3 on Windows XP sp1 and so is the development PC.

Now, I can think of several brute force approaches - setting the caption
font size in the click event and so on, but I'd really like to get to the
bottom of what is causing this. Has anyone seen this and fixed it?

Thanks in advance

 

[MattShoreson]

John,

I've experienced this before, and I thought it might have something t
do with freeze panes and differing resolutions between development an
production PCs.

It's a right pain to sort out and I figured it could be done b
ascertaining res size and then configuring zoom etc.

In the end I went with a menu item containing all bespoke functionalit
in the sheet. Using the workbook activate and deactivate the menu can b
added or removed at will.

Sorry not nore help!
Mat

 

[Dave Peterson]

This may not help, but I've always thought that the buttons from the Forms
toolbar behaved better.

Maybe you can replace your commandbuttons with Forms buttons and move/modify
your code into a General module.

 

[Guest]

You mean the excel forms buttons rather than the MSForms buttons?
This is deprecated by Microsoft - so it's a brute force approach that is
regressing the code. It may well as a workaround, but this seems to be a
very short term fix - I must check to see if 2007 supports the old style
buttons.

Perhaps someone from Microsoft can throw some light on this????

 

[Dave Peterson]

Yep. That's what I meant.

I don't use xl2007, but I haven't read that the controls from the Forms toolbox
no longer are supported.

I would think that if that were true, there would be a lot of posts warning
people of that.

And there aren't too many people from MS that read these posts. But maybe
you'll get lucky.

You mean the excel forms buttons rather than the MSForms buttons?
This is deprecated by Microsoft - so it's a brute force approach that is
regressing the code. It may well as a workaround, but this seems to be a
very short term fix - I must check to see if 2007 supports the old style
buttons.

Perhaps someone from Microsoft can throw some light on this????