[RESOLVED] Scope of Functions in Excel Add-In

[VBAhack]

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?