Quick question regarding custom functions...

Hi,

If you create a public cusotm function, does the original workbook ahve to be open to use this function in other workbooks?

Thanks

readered

or store it in an add-in but yes the workbook with the code in has to be open

It's a custom function. It must be installed in such a way as to be accessible to the workbooks where it will be employed.

1) Install the function specifically into each workbook where it is needed

PROS - the function travels with the workbooks, if you send one of them to anyone, the function still works

CONS - macros have to be enabled


2) Install the function in your Excel's PERSONAL.XLS file

PROS - macros do not have to be enabled when viewing the workbooks that use the function
- Function is available on your computer at all times, any workbook can use it

CONS - you might forget and send the workbook to someone who doesn't have your function installed in their PERSONAL.XLS so when they open the workbook they will see #NAME errors.



NOTE: If you opt for #1, you MUST install the function into each workbook. Just opening a workbook that has that function will NOT allow it to work in other opened workbooks. Only PERSONAL.XLS does that.