The user is always given the option to enable or disable macros if they have
chosen the appropriate security level. This is for their self protection as
their is no way to know if a macro is harmful or not. You can not overcome
this prompt with code contained in the workbook where you don't want the
prompt (in fact the prompt is given before any code is run). Think about
it. If it could be turned of by code, then there really would be no reason
to have the prompt.

--
Regards,
Tom Ogilvy


"Beau" wrote in message
...
Hello,
How do you select "Enable Macros" when Excel starts
without prompting the user? I'm a little new to Excel
programming. I don't want to give the user the option.
Thanks.

Beau