I have written several functions and subprocedures in a spreadsheet file. I
saved the file as an .XLA and then loaded the add-in, but chose not to copy
it to my local add-ins folder.

I read somewhere if you want to have a macro run code you have written it
must be a subprocedure. So I did that. However, when I go to the Macro menu
or create macro menu the subprocedures are not available.

What's weird is - I can write formulas in any workbook I open and I can
reference the code I wrote as a function and the formulas work great. So why
can't I 'see' the subprocedures to run macros?

Any help is greatly appreciated.

Seth