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