Greetings all

I am using the custom UI editor.

I see several examples on how to call a custom macro...seems easy enough.

I, however, have custom functions within my workbook that i would like to "call" using the ribbon.

Is this possible?

Thank you in advance

Dan

Yes it can be done, and quite easily (good news)!

Let's say you definea button to run your custom procedure

<button id="customButton1" label="Run My Custom Procedure" size="normal" onAction="RunMyProc" imageMso="RegionLayoutMenu"/>

Then you create a call back to run your procedure

'Callback for customButton1 onAction
Sub RunMyProc(control As IRibbonControl)
LaunchProc
End Sub

So what in fact is happening, is your ribbon button calls the Sub GenWip which in turn Call your procedure LaunchProc

Thanks for the help.

Is still not working however.

I applied everything you said but still says macro is not available.

Any ideas?

Thanks!

Dan

Where are you seeing "macro is not available"? Is that the exact error message? Is there an error number?

Thanks.

I get the message when i press the button i created on the ribbon.

I appreciate your help

Dan