Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Note: Not an answer, but more information.

It seems to be related either to the VBA option, or because it existed as a separate project than Standard. I set up a test spreadsheet, added a Basic macro from scratch, and it loaded perfectly. These macros work just fine without the VBA support option, so copied them over to a new module under standard, removed the VBA Project, and the functions load when the spreadsheet opens.

Important: This may not work for everyone, as some VBA code may need VBA support. It just happened to work in this instance.

I should have pasted the code as-in in a new module, complete with the VBA support flag to see if this was the problem or if it was because the code was in a separate project.