Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup table in addin
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup table in addin
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 "SCA" wrote in message om... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Table | Excel Discussion (Misc queries) | |||
Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
table lookup | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Pivot Table addin | Excel Discussion (Misc queries) |