You cannot stop them getting that message without setting your security
setting to low (which is a very bad idea), but you can take some defensive
action.

You can digitally sign the workbook so they don't get the message, or you
can try and make the workbook (seemingly) inoperable if the users disable
macros.

The standard way to approach this is as follows.
- create a worksheet with a message on explaining that for this workbook to
run it needs macros enabled, maybe even a few screenshots
- hide all other worksheets]
- add some code in the Workbook_Open event that un hides the other sheets,
but hides that sheet.


What happens is that if they do not enable macros, they will only see the
warning sheet, telling them how to do it. If the enable macros, it will
startup as the workbook it should be.


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Darin Kramer" wrote in message
...

Thanks Bob - works great. Any ideas for Question II ?


*** Sent via Developersdex http://www.developersdex.com ***