View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bill Renaud Bill Renaud is offline
external usenet poster
 
Posts: 417
Default Addin Macro Call

<<What is the correct format of the call statement for a addin workbook
that contains a macro in module1...

Something like:
YourProject.YourModule.YourSub

or

[MyProject.xls].[MyModule].Main

See the topics "Avoiding Naming Conflicts" and "Calling Procedures with the
Same Name" in Visual Basic Conceptual Topics.
--
Regards,
Bill Renaud