[RESOLVED] Scope of Functions in Excel Add-In

I have an Excel Add-In containing API declarations (Public Declare Sub ...) and Public Functions that call the API's.

In a new Excel file that references the above add-in, I can access the public functions of the add-in in worksheet formulas but not from a code module. A "Sub or Function not defined" error occurs if a function is referenced in a code module.

Is the scope of functions in an add-in ONLY spreadsheet formulas? Is there a way to access the functions in a code module?

After some digging around, I found the answer. Functions/Subs of worksheet A can be used by code modules of worksheet B if worksheet B references worksheet A in VBE/Tools/References.