Enable macro on opening workbook
How can I automatically enable Macro on opening my workbook(which contains 7
worksheets). -- ASU |
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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 03:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com