I created a .xla add-in file, and installed the add-in by checking the box
under Tools|Add-Ins.

But when I re-start Excel, I can't see in the VBA Editor any of the Add-In's
Macros (nor can I access the macros unless I explicitly open the .xla
file)...

Very grateful for any help... tks!

without looking into th exla code module, where would you expect to see the
procedures?

If in the IDE you set a redference to the xla, then its public procedures
become available.
make sure that when you save the file as an xla, that you rename the
VBAProject and the module names, otherwise the names will/may conflict with
other projects.

"SingaporeSling" wrote:

I created a .xla add-in file, and installed the add-in by checking the box
under Tools|Add-Ins.

But when I re-start Excel, I can't see in the VBA Editor any of the Add-In's
Macros (nor can I access the macros unless I explicitly open the .xla
file)...

Very grateful for any help... tks!

Thank you for the response.

How do I set a reference to the xla in the IDE? And what if I'm trying to
refer to an xla function in an excel worksheet? (It seems I need to play with
the links -- under edit|links menu -- in order to allow the worksheet to
reference the xla functions. Shouldn't this be automatic? Thanks again!


"Patrick Molloy" wrote:

without looking into th exla code module, where would you expect to see the
procedures?

If in the IDE you set a redference to the xla, then its public procedures
become available.
make sure that when you save the file as an xla, that you rename the
VBAProject and the module names, otherwise the names will/may conflict with
other projects.

"SingaporeSling" wrote:

I created a .xla add-in file, and installed the add-in by checking the box
under Tools|Add-Ins.

But when I re-start Excel, I can't see in the VBA Editor any of the Add-In's
Macros (nor can I access the macros unless I explicitly open the .xla
file)...

Very grateful for any help... tks!