Unfortunately, you can't, without using some kind of digital signature. Even
then, the user has to accept you as a trusted source.

http://support.microsoft.com/default...;en-us;Q288985

--

Vasant

"mot60" wrote in message
...
How do you ensure that the user allows macros when a workbook is opened?
If
macros aren't allowed, then functionality is lost.

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
No, otherwise what would be the point of allowing the user to set the
security level?

--

Vasant


"mot60" wrote in message
...
Is there a way to allow macros automatically when opening a workbook
using
code in the WorkBook_Open section?