Add-In Error

D

DavidW

I have an add-in that calls a public sub in a module to open a form as follows

1. The .OnAction event for the menu item is set to MyModule.ShowTheForm within the 'ThisWorkbook' object of My.xl
2. ShowTheForm is a public sub within MyModule and opens a UserForm with UserForm.Sho

The add-in works perfectly on my machine but as soon as I send the .xla file to the AddIns directory of another machine I get the following message

"The macro "My.xla!MyModule.ShowTheForm" cannot be found

Has anyone else experienced this or know what is causing the problem
 
B

Bob Phillips

Is the module in the add-in? If not, it is presumably not present.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

DavidW said:
I have an add-in that calls a public sub in a module to open a form as follows:

1. The .OnAction event for the menu item is set to MyModule.ShowTheForm
Click to expand...
within the 'ThisWorkbook' object of My.xla
2. ShowTheForm is a public sub within MyModule and opens a UserForm with UserForm.Show

The add-in works perfectly on my machine but as soon as I send the .xla
Click to expand...
file to the AddIns directory of another machine I get the following message:
 
D

DavidW

Hi Bob

When I open the VBA IDE from the .xla file the following objects are listed

Microsoft Excel Objects: Sheet1, ThisWorkboo
Forms: UserForm
Modules: ProgrammePlanModule (MyModule)
 
Top