The circumstance is that I created a User Defined Function (UDF) that I want to permanently 'install' to excel using a NON MACRO ENABLE FILE TYPE.
I tried saving the UDF in a .xlam file format, aka a Excel Addin file type, and then added the Addin to excel. When tried to user the UDF, I got the '#NAME' error.
I then went into the VBA Editor and compiled the VBA code (which included the UDF from the Addin xlam file). After I did this, I was able to use the UDF in my spreadsheet.
Does that answer the question, or is something still missing? Thanks.