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 View>Toolbars>Forms (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

OTOH, you completely lose the functionality of clicking on the command button
in edit mode and going to the VBA code. That's a huge bummer. So I would
still like a solution that involves retaining my current command buttons.

And it's a 20" monitor, not 200 as I posted in the first post.

Sorry for multiple posts, but I don't a mechanism to edit a post.

"opieandy" wrote:

> Man, I beat you guys again!
>
> I just changed the word "Private" to "Public" at the beginning of the VBA
> code and now the code section appears as an option to link the Excel command
> button to.
>
> "opieandy" wrote:
>
> > 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 View>Toolbars>Forms (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