View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default adding custom macro controls to Fluent RibbonUI

Hi Steve

If you use my samples in the UI editor you can read that you can click
on the create callbacks button to create the callbacks for every onaction

Copy them in a module of your workbook and add your code
http://www.rondebruin.nl/ribbon.htm

From the site

Generate Callbacks : This will create macros(callbacks) for each onAction you have in your xml.
Select all callbacks and copy them in a normal module in your workbook.
Try this in one of the examples and you will see that it is not so difficult.
After that you can insert the code between the Sub and End Sub line in the macros(callbacks)


--

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


"SteveDB1" wrote in message ...
Hello again.
I've finally got the menu structure for my customized ribbon menu.
Now I just need to connect the macros I have to each of the items/buttons.
As mentioned yesterday in my last post, I've read the pdf file from that
group in Britain--OALtd. While I see the "getItem..." components, I don't see
anything that specifically identifies how to connect my macros with the
components I made for the ribbon.
How can I do this?
My initialy thoughts would be to use the onAction="pathway to macro, and
macro name". I.e., c:\documents and settings\ user name\ application
data\microsoft\excel\xlstart\filename.xlsb!MacroNa me
However, the macros are stored in a structure based on ron DeBruin's
macro-module/menu.

how do I accomplish this?
Thank you in advance.