XL: How to Use a Custom Function in Another Workbook

In Microsoft Excel, you can create custom Microsoft Visual Basic for ... that contains the code, and how to call this custom function from another workbook.

support.microsoft.com