| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enable macro on opening workbook
How can I automatically enable Macro on opening my workbook(which contains 7
worksheets). -- ASU |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Enable macro on opening workbook
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Enable macro on opening workbook
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Enable macro on opening workbook
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Enable macro on opening workbook
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Enable macro on opening workbook
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run macro when opening workbook | Excel Discussion (Misc queries) | |||
| Passing selected workbook name and values to a macro | Excel Worksheet Functions | |||
| how to enable macro | Excel Worksheet Functions | |||
| Extract specific data into its own workbook via macro? | Excel Discussion (Misc queries) | |||
| Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Linear Mode
