There's an option under Tools|Macro|Security|security level.

If you change it to low, you won't be prompted. MS doesn't recommend this
setting, though.

And rename that macro to Auto_Open (with the underscore). And make sure it's in
a general module.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

ASU wrote:

OK. Having problems. When I open the workbook, I get a popup asking me enable
or diseable macro. How do I get it to enable macro automatically without
asking me.
--
ASU

"ASU" wrote:

Obrigado!
Ill see if it works
--
ASU


"Marcelo" wrote:

change the name of the macro to AUTOOPEN

eg
___________________________
Sub AutoOpen

your code

End Sub
___________________________

hth
regards from Brazil
Marcelo

"ASU" escreveu:

How can I automatically enable Macro on opening my workbook(which contains 7
worksheets).
--
ASU

--

Dave Peterson