Workbook Open Vs Auto_Open

[Soniya]

Hi all,

What diffetrecnce it makes a code under Workbook Open or
under Autpen

TIA

Soniya

 

[Rob Bovey]

What diffetrecnce it makes a code under Workbook Open or
under Autpen

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, Autpen always runs last), but I
haven't seen any that could easily be worked around.

I tend to use Autpen 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 *

 

[Chip Pearson]

Just adding to Rob's reply...The Autpen macro does not execute if the
workbook is opened via Automation; that is, if it is opened with VBA code.
In this case, the calling code would have to call "Workbook.RunAutoMacros
xlAutoOpen" to execute the Autpen macro. The Workbook_Open event is
called regardless of how the workbook is opened.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com (e-mail address removed)