Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same function in add-in and workbook module
I have an add-in with several UDFs. If I copy one or more of these
functions to a workbook module , I seem to get no trouble calling such function in that workbook. It also seems that the function which is actually used then is the one in the workbook, not the one in the add- in. The reason for doing so is that I want to distribute the workbook to other people with only the copied UDFs and without the whole add-in. I want to keep that workbook on my own computer as well , thus having the same UDF twice. Is this sound practice or should I expect trouble? Thanks for your advice. Herman |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same function in add-in and workbook module
I would suggest you rename the functions that you copy from your addin to
the workbook. It should not be too difficult for you to search & replace-all in formulas to switch between use of workbook/addin functions. If for some reason you prefer not use same names, after copying the functions into the workbook, close the original addin (also rename or move the file to a different folder). Recalc the workbook, save, close it. Reopen it (with the addin still closed). First good indication is if you do not get a missing link message, then check that all the formulas that call the UDF's point correctly with no #NAME? errors. If all looks OK it should be safe to distribute the workbook. Regards, Peter T wrote in message ... I have an add-in with several UDFs. If I copy one or more of these functions to a workbook module , I seem to get no trouble calling such function in that workbook. It also seems that the function which is actually used then is the one in the workbook, not the one in the add- in. The reason for doing so is that I want to distribute the workbook to other people with only the copied UDFs and without the whole add-in. I want to keep that workbook on my own computer as well , thus having the same UDF twice. Is this sound practice or should I expect trouble? Thanks for your advice. Herman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving Public Function From Workbook Module to XLA | Excel Programming | |||
Run worksheet module code from workbook module? | Excel Programming | |||
Automatically Delete WorkBook 2 modules by using Workbook 1 module | Excel Programming | |||
Copy VBA Module and Form from Workbook to another workbook | Excel Programming | |||
Macro, Module, function, sub and This workbook and sheets ? | Excel Programming |