Auto_Open Workbook_Open

  • Thread starter yngve.angelskaar
  • Start date
Y

yngve.angelskaar

What is the diferent between Auto_Open and Workbook_Open, when I use
Auto_Open in a module and open the workbook with a macro the Auto_Open
is not runing, workbook_Open runs.

Regards Yngve
 
B

Bob Phillips

That is essentially the difference.

Auto_Open is the original way of having a macro run at workbook startup, but
with the introduction of events in XL97, the Workbook_Open event was
introduced. Auto_Open is retained for compatibility.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
C

Chip Pearson

They are very similar. Auto_Open is older than the Workbook_Open
event (events were added in Excel 97). One major difference is
that if a workbook is opened via VBA (as opposed to the
File..Open menu item), Auto_Open will not run, while
Workbook_Open will.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
E

evgny

Bob Phillips skrev:
That is essentially the difference.

Auto_Open is the original way of having a macro run at workbook startup, but
with the introduction of events in XL97, the Workbook_Open event was
introduced. Auto_Open is retained for compatibility.

--

HTH

RP
(remove nothere from the email address if mailing direct)
Click to expand...
 

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
setattr 2
Unexpected file change 4
Auto_Open Code on Worksheet 2
Adding custom menus to existing excel application 0
model in excel: auto_open and in thisworkbook workbook_open 0
Defining public/global variables in more than one place 1
Triggering auto_open 6

Top