ericontheroad
New Member
- Joined
- Mar 7, 2009
- Messages
- 4
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.
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
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.
Code:
Sub MyMacro1()
FmMkeffect.Show
End Sub
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