Excel 2007 Ribbon

[hitmonkong]

Does anyone know if we can set a default value in the dropdown menu in a new
ribbon in Excel 2007 (like Arial is the default value for Fonts dropdown menu
in Excel 2003). I am having a hard time finding the code for it. I am
developing the ribbon in Office 2007 Custom UI Editor.

Thanks,
hitmonkong

 

[Ron de Bruin]

You can see it in the workbook I send you

 

[Ad ios]

You can see it in the workbook I send you

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm






- Tekst uit oorspronkelijk bericht weergeven -

can you send me this workbook also ,(thanks)

 

[Ron de Bruin]

Sure

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

 

[ErNeu]

Sure

Hi,

I'm also looking for that info...
can anyone pls post the syntax in the xml or send me the workbook,
pls?

many thanks in advance
eric

 

[ErNeu]

Hi,

I'm also looking for that info...
can anyone pls post the syntax in the xml or send me the workbook,
pls?

many thanks in advance
eric

Hi again,

just found it - and for everyone who's looking this up - found it
here: http://word.mvps.org/FAQs/Customization/Customising the Ribbon - Advanced.htm

getSelectedItemIndex= has to be set...

sample:

<dropDown id="DD1" label="Run Macro"

getItemCount="RibbonControl.GetItemCount"

getItemLabel="RibbonControl.GetItemLabel"

getSelectedItemIndex="RibbonControl.GetSelectedItemIndex"
onAction="RibbonControl.MyDDMacro" />


'Callback DropDown GetSelectedIndex
Sub GetSelectedItemIndex(ByVal control As IRibbonControl, ByRef Index)
'This procedure is used to ensure the first item in the dropdown is
selected when the control is displayed
Index = 0
End Sub

kind regards