Dan, That's a good summary of the situation and I'd refer users to
it... that is, if it started out by explaining the MS approved and
safest approach i.e. digitally signing the VBA project. I don't think
I could recommend anything but the highest security setting, even if
virus scanners are installed. Digital signatures allow macros to be
enabled while maintaining the high security setting. For details see
MSDN e.g.

OFF2000: Overview of Digital Certificates
http://support.microsoft.com/default...b;en-us;206637

Please post back if you decide to add such details to your site, I'd
be genuinely interested.

--

(Dan) wrote in message . com...
Dennis,

I have the same problem. One thing that seems to help in my situation
is to direct new users to a little explanatory web page I put
together, found at www.qsl.net/ac6la/adhoc/vcheck.html. I put a link
to that page right next to the download link for my applications, with
big bold letters saying something like "This workbook will not
function correctly if macros are not enabled. See here for more
info."

Of course, YMMV.

Dan

(DennisE) wrote in message ...
My applications contain macros. Many of the users they
are distributed to just stare at the notification message that
comes up at loading time stating that the macros are disabled,
not knowing what to do next.