Can't see macros in .xla file

D

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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top