How can I run a UserForm from XLAM addin (Excel 2013)?

[simurq]

I searched for an answer to no avail yet...

The Custom UI xml file contains the following (XML brackets replaced with regular ones):

<group id="gSettings">(group id="gSettings")
(button id="bSettings" label="Settings" size="large" onAction="ShowSettingsForm" image="settings-btn" /)
(/group)

This is the macro itself inside a separate module:

Sub ShowSettingsForm_Click()
frmSettings.Show
End Sub

I tried to name the macro both with and without the "_Click" part. But it doesn't work either.

Error message that pops up when pressing on the addin button:

"Cannot run the macro 'ShowSettingsForm'. The macro may not be available in this workbook or all macros may be disabled"</group>

Any help is appreciated!

 

[RoryA]

The macro should start with:

Sub ShowSettingsForm(ByVal control As IRibbonControl)

and should be in a normal module in the add-in.

 

[simurq]

It's awesome! Thank you VERY much, Rory!!!

 

[RoryA]

Glad to help.