Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_Open over Private Sub Workbook_Open()
I am just wondering, is there any advantage to using an Auto_Open module
over just placing that code in a Private Sub Workbook_Open() module under ThisWorkbook? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_Open over Private Sub Workbook_Open()
I find that explaining how to use Auto_Open is easier than explaining how to use
workbook_open. But to me, they're pretty much interchangeable. There are some things (creating an application event, for example) that makes the workbook_open a more logical choice. And there are differences in behavior. If you use one macro to open another workbook, then you have to stop the workbook_open event from firing (if you don't want it to run) application.enableevents = false set wkbk = workbooks.open(filename:=... application.enableevents = true On the other hand, if you want to run the auto_open procedure, you'll have to run it explicitly (using someworkbookthatjustopened.RunAutoMacros which:=xlAutoOpen.runautomacros They're kind of opposite in behavior. ordnance1 wrote: I am just wondering, is there any advantage to using an Auto_Open module over just placing that code in a Private Sub Workbook_Open() module under ThisWorkbook? -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_Open over Private Sub Workbook_Open()
Thanks
"Dave Peterson" wrote in message ... I find that explaining how to use Auto_Open is easier than explaining how to use workbook_open. But to me, they're pretty much interchangeable. There are some things (creating an application event, for example) that makes the workbook_open a more logical choice. And there are differences in behavior. If you use one macro to open another workbook, then you have to stop the workbook_open event from firing (if you don't want it to run) application.enableevents = false set wkbk = workbooks.open(filename:=... application.enableevents = true On the other hand, if you want to run the auto_open procedure, you'll have to run it explicitly (using someworkbookthatjustopened.RunAutoMacros which:=xlAutoOpen.runautomacros They're kind of opposite in behavior. ordnance1 wrote: I am just wondering, is there any advantage to using an Auto_Open module over just placing that code in a Private Sub Workbook_Open() module under ThisWorkbook? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto_open OR Workbook_open | Excel Programming | |||
Auto_Open Workbook_Open | Excel Programming | |||
Cannot get Auto_Open or Private Sub Workbook_Open() to run at star | Excel Programming | |||
Auto_Open Vs Workbook_open | Excel Programming |