Custom Ribbon Button and Macros

[lfcjr54]

I have a macro which I assigned to a custom butoon in Excel 2003. This macro was run by many users in my organization. I would like to duplicate the funcationality in Excel 2007. I have created the xml code to add a custom button to the Ribbon using the CustomUI Editor. This works well. I have also copied the macro into an .xlam file.

I cannot get the button press to execute the macro. How do I establish the relationship between the button and the macro?

 

[Derek Brown]

Hello and welcome to The Board.
In the CustomUI Editor, you will probably have 'validated' the XML.
You should then click the 'Generate Callbacks' button and copy that code to a (VBA) module in your workbook. Modify if necessary to call your code.
Macros will need to be enabled for the code to run.
You may find it easier to test it first in a 'normal' workbook (.xlsm) before converting to an add-in.

 

[lfcjr54]

Thanks for the welcome and for your help. It works great!