VBA to compile modules upon opening workbook

[westy1]

I need a way to compile VBA code in a module upon opening the module. Any ideas?

Thanks.

 

[SamTYler]

why? what circumstance do you have in mind that requires that?

 

[westy1]

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.