Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Auto_Open Workbook_Open

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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Auto_Open Workbook_Open

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)


wrote in message
oups.com...
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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Auto_Open Workbook_Open

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


wrote in message
oups.com...
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



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default Auto_Open Workbook_Open


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)


wrote in message
oups.com...
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


  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default Auto_Open Workbook_Open

Thang`s for replying and god explanation

Regards yngve

Chip Pearson skrev:
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


wrote in message
oups.com...
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto_Open/Workbook_Open subroutines showing SCREENUPDATING WhytheQ Excel Programming 2 July 5th 05 03:50 PM
Cannot get Auto_Open or Private Sub Workbook_Open() to run at star Paul Moles Excel Programming 0 October 28th 04 03:53 PM
Auto_Open and Workbook_Open Erich Neuwirth Excel Programming 1 July 14th 04 01:19 AM
Auto_Open and Workbook_Open in Addins Erich Neuwirth Excel Programming 1 July 11th 04 06:54 PM
Auto_Open Vs Workbook_open Soniya Excel Programming 2 September 23rd 03 03:56 PM


All times are GMT +1. The time now is 01:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"