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?

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)

"dch3" wrote:

> 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?

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/...oadcommandbars



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"dch3" <(E-Mail Removed)> wrote in message news:723ACDA0-DE0C-4F17-9FDF-(E-Mail Removed)...
> 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?