Lookup table in addin

[SCA]

I but some data in a worksheet in a workbook and made some functions
that would look up variables off of this worksheet. I saved this
workbook as an add-in and try to use my functions, that were working
in the workbook before I saved it as an add-in, and they did not work.
So I have to activate the specific worksheet in the addin that i am
looking up off of...or do I have to activate the entire add-in
workbook....how do I go about doing this...thanks for your help

 

[Tom Ogilvy]

You need to design your code so it doesn't work with the ActiveSheet, but
refers to the sheet in the addin specifically.

It would be difficult (if not impossible) to make the hidden sheet in the
Addin the activesheet or at least select on it.

Regards,
Tom Ogilvy