LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,489
Default Ribbon's equivalent to CommandBars.ActionControl

If you have not already have a read of Stephen Bullen's chapter on Ribbonx
http://www.oaltd.co.uk/Excel2007ProgRef/Default.htm

The getXXX callbacks are, to me at least, a bit misleading in their name.
The do not get/return anything to you as the programmer. Instead they
get/return information to the Ribbon. So you use it to control the
Description information that the control uses. Rather than as the name
suggests get the description information from the control.

And yes the VBA functionality of the ribbon is limited compared to the
Commandbar object model. That said the ribbon can be much easy to produce
and maintain than commandbar coding *if* you are using controls that already
exist. So to add a fully functioning button to make stuff bold requires only
a reference in the xml to the idMso. Plus creation and destruction of the
ribbon is automatic when the workbook opens and closes. Also when it
activates or deactivates the ribbon controls are automatically
removed/returned.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Paul Martin" wrote in message
...
As an addendum, I've been playing around with the button's Callbacks.
I thought getDescription might be useful, but I can't work out how it
is used, what it is used for. Can anyone enlighten me?

TIA


 
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
How to set off CommandBars hstijnen Excel Programming 1 November 22nd 06 04:54 PM
CommandBars vs CommandBars(1).Controls Sean Excel Programming 3 April 3rd 06 01:34 PM
help --- Commandbars wAyne Excel Programming 5 February 17th 06 08:17 PM
CommandBars defj Excel Programming 2 November 16th 03 12:57 AM


All times are GMT +1. The time now is 03:23 PM.

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

About Us

"It's about Microsoft Excel"