ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   the incredible shriking font (https://www.excelbanter.com/excel-programming/454259-incredible-shriking-font.html)

[email protected] March 27th 19 07:08 PM

the incredible shriking font
 
I have a spreadsheet with three ActiveX command buttons that launch some simple routines I created for a colleague. The routines work without issue, but each time a command button is selected, the caption font gets smaller, eventually getting too small to read.

Closing out of the workbook, then relaunching restores the font to the correct size - sometimes. Sometimes the fonts just stay small or disappear.

Any suggestions?

Adrian Caspersz March 27th 19 07:36 PM

the incredible shriking font
 
On 27/03/2019 19:08, wrote:
I have a spreadsheet with three ActiveX command buttons that launch some simple routines I created for a colleague. The routines work without issue, but each time a command button is selected, the caption font gets smaller, eventually getting too small to read.

Closing out of the workbook, then relaunching restores the font to the correct size - sometimes. Sometimes the fonts just stay small or disappear.

Any suggestions?


google "shrink caption excel button"

https://social.msdn.microsoft.com/Fo...forum=exceldev


--
Adrian C


All times are GMT +1. The time now is 06:02 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com