View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default make macros (sub) work for add-in?

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