No, not in an add-in, it just works that way. You can still run them though
VBA
Application.Run "myaddin.xla!mymacro"
or Excel
ToolsMacroMacros ... (or Alt-F8) and in the Macro Name editbox type the
addin name and macro name as above.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
wrote in message
oups.com...
Hello,
I've followed this tutorial (http://www.fontstuff.com/vba/vbatut03.htm)
to build an add-in file for my excel 2003. It lists functions when the
add-in is loaded in the function menu. However the main portions of my
code is subrountines. I run them from the Macro menu. After I saved the
file as an add-in file and loaded it into my excel, I no longer see the
subs in the macro menu. Is there a way to make them show whenever excel
is opened?
Thanks