A very nice example of this is found in chapter 20 of the Professional Excel
Development book by Bullen, Bovey, and Green. Under the Practical Examples
at the end of the chapter, look for "Standard EXE - Creating a Front Loader
for Your Excel Application". This book is full of many practical examples
like this one.

Here's a link to the book:
http://www.amazon.com/exec/obidos/re...&creative=9325

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


"Jon Peltier" wrote in message
...
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