Text only in toolbar buttons

[Thierry Paradis]

Hi!

I would like to know how to set custom toolbar buttons to display text only
and no picture?

Thanks,

Thierry Paradis

 

[Bob Phillips]

Set the style property to msoButtonCaption

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Tom Ogilvy]

set the style property of the control to

msoButtonCaption


commandbars("Custom1").Controls(3).Style = msoButtonCaption

Other choices are (from xl2002 help)

msoButtonAutomatic
msoButtonCaption
msoButtonIcon
msoButtonIconAndCaption
msoButtonIconAndCaptionBelow
msoButtonIconAndWrapCaption
msoButtonIconAndWrapCaptionBelow
msoButtonWrapCaption