If under Tools/Macro/Security, on the Trusted Publishers tab you have
"Trust all installed add-ins and templates turned on" and the macro is
located in a trusted location then you won't be prompted to
Enable/Disable macros with Medium security and they will still run
with High security.
Under the Security Level tab, I have Medium Security set.
Under the Trusted Publisher's tab there are two check boxes:
[x] Trust all installed add-ins and templates
[ ] Trust access to Visual Basic Project
Where is the macro located? Is it in your Personal.xls folder in the
XLStart folder? If so then the XLStart folder is a trusted location.
I'm not sure. I just created the macro from within the spreadsheet.
It appears that my computer is not a trusted location. I just tried
to open macros using the Visual Basic editor, but nothing showed up.
This has happened before, and I futzed around for a while and finally
was able to get something to show up. Even though I was able to
write a complicated set of macros, I never have been able to figure
out the structure (modules, classes, projects, etc.). View Code
creates something new. View Project Explorer looks promising, but
clicking on each element does not show my code. Ahh, found it, I
needed to double-click on module 1. That's where I see my code, but
I don't see where it gets stored.
