Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook Open Vs Auto_Open
Hi all,
What diffetrecnce it makes a code under Workbook Open or under Auto_Open TIA Soniya |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook Open Vs Auto_Open
"Soniya" wrote in message
... What diffetrecnce it makes a code under Workbook Open or under Auto_Open From a coding standpoint it really doesn't make any difference at all. I'm sure you could come up with some obscure situations in which the sequence of event firings matter (of all the procedures that run automatically when a workbook opens, Auto_Open always runs last), but I haven't seen any that could easily be worked around. I tend to use Auto_Open simply to avoid placing any code in the code module behind the ThisWorkbook object. Any code in this area has the possibility of becoming corrupt. If corruption does occur in this area, there's no way to fix it short of rebuilding the whole workbook. This obviously doesn't apply if you're using a WithEvents class module to trap the Workbook_Open event from some other workbook, though. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) |