Jim -

Without disabling security of the host computer, you could write a short program in
VB that when double-clicked will open your file in Excel (not VBA, but its big
brother, which makes full executables). One Excel program can open another workbook
that contains code, without triggering the warning, and so can the VB program.

Short of this, the suggestion by Jim Thomlinson is the best, to make the workbook
useless if macros are disabled, but with obvious instructions (large bold red text
doesn't hurt) about what to do to correct the situation.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


JK wrote:

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