Calling Add-In subroutines from other modules
Tom, I do have the add-in, and I can see it in the
project list with any workbook i open. However, if I try
to call a subroutine that is in the Add-In, FROM another
workbook module, it doesn't find the routine. If I copy
that routine into the workbook module I am calling from,
it works fine.
Steve
-----Original Message-----
With your workbook that needs to reference it as the
active project,
in the VBE, Tools=References and select the ADDIN
--
Regards,
Tom Ogilvy
"sclark" wrote in
message
...
I have a bunch of common subroutines that I have placed
in an Add-In
module. This module is available whenever I open Excel,
but I cannot
reference the subroutines in the Add-In module, from
other workbook modules.
How is this done?
Steve
.
|