J
John.Greenan
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
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