make macros (sub) work for add-in?

[dodozhang21]

Hi, I've followed this tutorial 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 it show whenever excel is opened?

Thanks