ExcelBanter - Addin Macro Call

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Addin Macro Call (https://www.excelbanter.com/excel-programming/403033-addin-macro-call.html)

Rick

Addin Macro Call

What is the correct format of the call statement for a addin workbook that
contains a macro in module1 with ThisWorkbook properties set to addin = true.

Bill Renaud

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

All times are GMT +1. The time now is 04:48 AM.