Office 2007 Ribbons/toolbars.

[Chris Watts]

I have written, in vba, a macro that creates a floating custom toolbar with
action buttons to access my library of macros (about 20 of them). This
works just fine with Excel 2000.
On tranporting this to Excel 2007, as expected, this toolbar just appears as
a set of small action buttons along the addin tab - the result is not very
user friendly. Clearly I need to rewrite it to create a ribbon (presumably)
with bigger buttons and dropdown lists. Can somebody please point me to
some examples of how to program this sort of ribbon in vba?

TIA
Chris

 

[scw-tzg]

These may help...

http://msdn.microsoft.com/en-us/lib...TaskPanesRibbonVBA_ChangingRibbonUIProperties

http://msdn.microsoft.com/en-us/library/aa338202.aspx