Can't see macros in .xla file

[dch3]

I've saved several VBA subs in a workbook as an Excel add-in (.xla). The
add-in is showing as installed and its visible in the VBA project explorer.
However, when I go to run the macro TOOLS > MACRO > MACROS or try to assign
the macro to a custom menu item on a tool bar, the subs are not visible.
Ideas?

 

[DomThePom]

One of:

1. Subs declared as private
2. Subs require one or more arguments
3. Module declared as private ('Option private module' in declarations
section)

 

[Ron de Bruin]

That is normal

Create a menu for the add-in

Debra Dalgleish's (Toolbar example from Dave Peterson)
http://www.contextures.com/xlToolbar02.html

Creating Custom Menus (John Walkenbach)
http://www.j-walk.com/ss/excel/tips/tip53.htm

Ole P. Erlandsen's Web Site (Example workbooks)
http://www.erlandsendata.no/english/index.php?d=endownloadcommandbars