Add Ins Excel Udf. Go to developer excel add ins. You also have to reference the personal macro workbook when you call the function which makes the process a little less simplified.
Excel 2002 brought in automation add ins a technology that allows writing user defined functions for use in excel formulas. Excel automation add ins are supported starting from excel 2002. The add in file contains vba code to expand excel s built in features and functions by adding new commands functions dialog boxes etc.
Excel on the web and windows connected to a microsoft 365 subscription allow you to coauthor in excel.
Go to developer excel add ins. They can be opened for single use or installed to ensure the features and functionality are always available. Save and close the excel workbook. Select excel add ins in the drop down list and then hit go.