View Single Post
  #1  
Old June 4th, 2010, 11:53 PM posted to microsoft.public.excel.misc
opieandy
external usenet poster
 
Posts: 36
Default Command Button - Shrinking Font

I have a new 200" landscape monitor that replaced my traditional 17". The
resolution automaticallyl resized on connection and looks fine.

However, when I click a command button, the font size shrinks. It stays at
that level until I click a different button and then return to the original
button, when it shrinks again. It will eventually become invisible to the
naked eye.

Internet research seems to indicate this is a bug. A standard Excel button
accessed from ViewToolbarsForms (not a VBA command button accessed from
Control Toolbox) seems to maintain its font size, but I don't know how to
link the Excel button to my VBA code. It only accepts standard macros.

I would love to stick with the command buttons but will switch to the Excel
buttons if that works. Please advise of a solution.

Thanks!

Chris