brothertruffle880
asked on
Excel 2013 - VBA Add-in - Newbie question - Can't see or run macros
Excel Add-in newbie question:
I have an Excel add in that I just loaded. TestofAddin.xlam
I want to run the macro "test" which is in a module1 in the add-in file. When I press Alt+8, I don't see the macro listed.
How can I run the macro called "test"?
I have an Excel add in that I just loaded. TestofAddin.xlam
I want to run the macro "test" which is in a module1 in the add-in file. When I press Alt+8, I don't see the macro listed.
How can I run the macro called "test"?
It must start with just Sub or Function. In other words no "Private" or "Public".
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi there! :)
Macros and Subroutines without arguments in add-ins do not appear in the Macros dialog. But you can try out this code.
Macros and Subroutines without arguments in add-ins do not appear in the Macros dialog. But you can try out this code.
Call TestofAddin.test(routine parameters)