Hi Jim

A macro can not allow itself to run, no. But once it (or anything else, like
a small external exe file) runs; the security setting is a registry key in
HKEY_CURRENT_USER\Software\Microsoft\Office\(versi on)\Excel\Security
and code can alter registry keys. It is not considered good practice, but a
man's got to do what a man's got to do.

HTH. Best wishes Harald

"JK" skrev i melding news:aC2sd.604$S33.511@trnddc03...
My application installs with a ton of messages that inform the user to
ENABLE MACROS when they open the program. I have even digitally signed it
so
(when their Excel security level is set to HIGH or MEDIUM) they can select
me as a trusted source and enable macros. Guess what? Users don't read the
instructions. So many of them still don't enable the macros and wonder why
the program doesn't function properly.

Is there a way to reset the security with VBA when my program opens? The
phone calls are killing me.

Thank you in advance.

Jim Kobzeff