Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.office.developer.vba
external usenet poster
 
Posts: 8
Default 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


  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.office.developer.vba
external usenet poster
 
Posts: 11,272
Default 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




  #3   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.office.developer.vba
external usenet poster
 
Posts: 27,285
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
text in custom toolbar buttons fuzzy Excel Programming 1 September 19th 05 01:54 PM
Toolbar Buttons bmac Excel Discussion (Misc queries) 2 March 8th 05 11:05 PM
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! Kevin Waite Excel Programming 2 March 3rd 04 03:31 PM
saving toolbar buttons on custom toolbar Paul James Excel Programming 12 August 6th 03 08:28 AM
Toolbar Buttons Bob Phillips[_5_] Excel Programming 0 August 5th 03 10:34 PM


All times are GMT +1. The time now is 10:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"