Text only in toolbar buttons
 

Hi!

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

Thanks,

Thierry Paradis

Text only in toolbar buttons
 

Set the style property to msoButtonCaption

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Thierry Paradis" wrote in message
...
Hi!

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

Thanks,

Thierry Paradis

Text only in toolbar buttons
 

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


--
Regards,
Tom Ogilvy


"Thierry Paradis" wrote in message
...
Hi!

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

Thanks,

Thierry Paradis