Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to set off CommandBars | Excel Programming | |||
CommandBars vs CommandBars(1).Controls | Excel Programming | |||
help --- Commandbars | Excel Programming | |||
CommandBars | Excel Programming |