UDF Description and UDF Arguments Descriptions Not Saving with Application.MacroOptions

All of these UDFs are stored in a separate .xla file. I'm not very familiar with those, but all the functions are automatically available in any new workbook.

XLA files also run Workbook_Open and Application-level event handlers. Run your setup macro from the XLA's Workbook_Open event handler.

That worked great. Just to clarify, will I need to include a function description sub for each of my custom functions in the Workbook_Open event handler? Or is there a way to run the sub once and have the descriptions permanently saved?

There are may ways to handle this. One HUGE separate macro with setup for every UDF. A huge Workbook_Open with all this setup. Separate macros for each UDF.

My own preference would be table-driven design. XLA files also need to have at least one worksheet, but it's never seen. Nevertheless, it's there. You could use it to store udf name in column 1, udf description in column 2, and individual argument descriptions in the subsequent columns. Use one macro (separate from but called by Workbook_Open) to iterate through the table by row, gathering the parameters for Application.MacroOptions, then calling it with those parameters.

That's a great idea. I'm trying to open a worksheet in the .xla file but can't. How do you view the .xla file worksheet?

Now I'm getting Run-time error '1004': Cannot edit a macro on a hidden workbook. Unhide the workbook using the Unhide command.

For the .xla file in the Properties window of ThisWorkbook, I change IsAddin to False. This makes the worksheet visible. I made a table as you suggested above. Then I changed IsAddin back to True before saving and closing. Here is my code for Workbook_Open:

Please Login or Register  to view this content.

The AddFunctionDocumentation Sub is in a module, code below:

Please Login or Register  to view this content.

Please let me know if you have any suggestions.

This is why I hate this sort of thing. Too many glitches. I had to recreate an extremely oversimplified add-in to test.

Looks like you need to toggle the add-in back and forth from add-in, to not add-in, to add-in. See the Workbook_Open code in the workbook attached below. Actually, I had to put the .XLAM into a .ZIP file for this site to accept it. You'd need to extract the .XLAM from the .ZIP file.