Another option is to write a program in VB which opens the workbook for you.
Workbooks which open through automation are implicitly trusted, since the
program that opens them (the VB program) are assumed to have been opened on
purpose.

This approach is good for unsophisicated users, as you can put an icon for
the VB program on the desktop for the users to launch the program.

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


"cfman" wrote in message
...
HI all,

When the users open my Excel/VBA sheet, they met with a window asking if
Macro should be enabled.

My users are not that sophisticated... so I would like everything simple
for them. Is there a way to get rid of such complications?

Thanks