Enable macro on opening workbook

[ASU]

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

[Marcelo]

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

[ASU]

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

[ASU]

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]

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

[Dave Peterson]

Ps. If you share this workbook with others, then they'll have to toggle that
same setting. It's a user by user setting--not a workbook setting.

Dave Peterson wrote:
>
> 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

--

Dave Peterson