Can't see macros in .xla file
 

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?

Can't see macros in .xla file
 

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?

Can't see macros in .xla file
 

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" wrote in message ...
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?