We help IT Professionals succeed at work.

Excel 2013 - VBA Add-in - Newbie question - Can't see or run macros

brothertruffle880
brothertruffle880 asked
on
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"?
Comment
Watch Question

Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
It must start with just Sub or Function. In other words no "Private" or "Public".
Production Manager
Commented:
Probably you mean Alt + F8. Add-in macros don't appear in the list of macros. You should still see them in the VBE, where you can use the Run command.
NoahHardware Tester and Debugger

Commented:
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