Open the VBE at the said function.
What kind of module is it in? (Sheet code-module, Standard code-module, ThisWorkbook code-module), and which workbook is it in; the same one as the sheet which has the function in one of its cells?, perhaps PERSONAL.XLSB?


Attach the workbook, it's a lot easier.