Call a Form from an addin

[ericontheroad]

Hi
Note that I tested the below in a Workbook then recreated the code in a xla workbook. It worked in a regular workbook but the call path errors out in the xla.

In a regular workbook, I had a sub macro simply calling the form.

Sub MyMacro1()
    FmMkeffect.Show
End Sub

I saved this same sub in the xla module but the path doesn't seem to be recognized. Is there something to be added because it's now a xla workbook?

My addin is creating a Menu bar in excel. My target was to call Sub MyMacro1 from the menu bar and call the form that way.
Thansk

 

[GTO]

Presuming you have the xla installed, how are you calling the procedure 'MyMacro1'?

 

[GTO]

Oops. Critters musta hit the Post Reply button when I wasn't lookin'.

The below presumes an .xla filename of 'Temp.xla' and that the procedure 'MyMacro1' is in 'Module1'.

Sub CallIt()
    
    Application.Run "Temp.xla!Module1.MyMacro1"
        
End Sub