Link to home
Create AccountLog in
Avatar of brothertruffle880
brothertruffle880Flag for United States of America

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"?
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

It must start with just Sub or Function. In other words no "Private" or "Public".
Avatar of John Korchok
John Korchok
Flag of United States of America image

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Hi there! :)

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)

Open in new window