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"?
VBAMicrosoft ExcelMicrosoft Office
Last Comment
Noah
It must start with just Sub or Function. In other words no "Private" or "Public".
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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)