View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JK JK is offline
external usenet poster
 
Posts: 78
Default Reset Security Level with VBA?

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