Auto_Open Vs Workbook_open

S

Soniya

Hi all,

what difference it makes having code under Auto_open or
under Workbook_open

TIA

Soniya
 
J

John Wilson

Soniya,

Workbook_Open is an "event" that "fires" whenever a workbook
is opened.
Auto_Open is a "sub" that Excel recognizes and runs when a workbook
is opened.
The main difference is that the Workbook_Open "event" fires whether
the workbook is opened manually or via code (from another workbook).
The Auto_Open will only run when the workbook is opened manually.

John
 
K

keepitcool

Hi Soniya..


workbook_open runs first and auto_open next

When you open a book manually:
BOTH will run UNLESS you keep SHIFT key pressed.

When you open a book with vba:
the auto_open WILL NOT run UNLESS you add the line (after open)
ActiveWorkbook.RunAutoMacros xlAutoOpen

the workbook event code WILL run UNLESS you add (before open)
Application.EnableEvents = FALSE

I think Auto_open was left in for backward compatibility with excel4
macros. Personally I'd use Workbook_Open


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto_Open over Private Sub Workbook_Open() 2
Auto_Open Workbook_Open 4
Workbook Open Vs Auto_Open 2
Auto_Open and Workbook_Open 1
Mysterious auto_open 1
Auto_open from Worksheet Object Code 1
Which Fires First? 4
XL97 Private Sub Workbook_Open() Not Working 6

Top