Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_open OR Workbook_open
Hi,
I have a couple of quaestions... 1. Which of these two events occurs first when an excel workbook is opened? 2. Does this also depend on whether the Excel application (not the particular workbook) is already open? I'm asking these questions in regard to scheduling the macro for a later time... Any help would be greatly appreciated Thanks, -- Baapi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_open OR Workbook_open
workbook_open first
makes no difference whether Excel started or not, it only makes a difference if opening the workbook from code, then auto_open doesn't fire. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Baapi" wrote in message ... Hi, I have a couple of quaestions... 1. Which of these two events occurs first when an excel workbook is opened? 2. Does this also depend on whether the Excel application (not the particular workbook) is already open? I'm asking these questions in regard to scheduling the macro for a later time... Any help would be greatly appreciated Thanks, -- Baapi |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_open OR Workbook_open
A quick test with a MsgBox function in each procedure shows that the
Workbook_Open fires first, regardless of whether the Excel application is already running. Note that before either runs you will likely get the 'Ok to run macros' dialog. Cheers, Dave "Baapi" wrote: Hi, I have a couple of quaestions... 1. Which of these two events occurs first when an excel workbook is opened? 2. Does this also depend on whether the Excel application (not the particular workbook) is already open? I'm asking these questions in regard to scheduling the macro for a later time... Any help would be greatly appreciated Thanks, -- Baapi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto_Open Workbook_Open | Excel Programming | |||
Cannot get Auto_Open or Private Sub Workbook_Open() to run at star | Excel Programming | |||
Auto_Open and Workbook_Open | Excel Programming | |||
Auto_Open and Workbook_Open in Addins | Excel Programming | |||
Auto_Open Vs Workbook_open | Excel Programming |