Edgar
02-03-2007, 02:23 AM
Could use some help on this one?
I have an Excel add-in (with various functions and procedure in multiple modules) that many people in my work group use. However, the add-in is not available to everyone within the company.
Clearly, if a workbook with custom functions located in the add-in is sent to someone else, the functions no longer work.
I originally thought I could solve this problem by coping the module with the custom functions from the add-in to the workbook. I got it to do this just fine.
The problem now is that the formulas in the workbooks, written before the module is copied to the workbook, refer to the add-in and show up as broke links when opened without the add-in, even though a copy of the functions are located in the workbook.
The same is true going the other way. Formulas that refer to the workbook version of the functions do not automatically find the add-in functions when the workbook module is removed.
I don't want to break the links because I want to make sure everything still calculates.
Finally, I thought about just adding the module to every work book as it is created or opened, but I don't want my co workers to have to accept the enable macro options for every workbook they open.
Any thoughts?
I have an Excel add-in (with various functions and procedure in multiple modules) that many people in my work group use. However, the add-in is not available to everyone within the company.
Clearly, if a workbook with custom functions located in the add-in is sent to someone else, the functions no longer work.
I originally thought I could solve this problem by coping the module with the custom functions from the add-in to the workbook. I got it to do this just fine.
The problem now is that the formulas in the workbooks, written before the module is copied to the workbook, refer to the add-in and show up as broke links when opened without the add-in, even though a copy of the functions are located in the workbook.
The same is true going the other way. Formulas that refer to the workbook version of the functions do not automatically find the add-in functions when the workbook module is removed.
I don't want to break the links because I want to make sure everything still calculates.
Finally, I thought about just adding the module to every work book as it is created or opened, but I don't want my co workers to have to accept the enable macro options for every workbook they open.
Any thoughts?