Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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/newsgroups...303&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 -- www.alignment-systems.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 - Font size in legend decreases with each file open | Charts and Charting in Excel | |||
Font Size of Radio Buttons | Excel Discussion (Misc queries) | |||
Button font size changes on click | Excel Discussion (Misc queries) | |||
When I click buttons I have added the font or button resize, Why? | Excel Discussion (Misc queries) | |||
Command Buttons - can't click or open properties | Excel Programming |