Add-In Error

[Guest]

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

 

[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)

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.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

file to the AddIns directory of another machine I get the following message:

 

[Guest]

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)