Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default Excel VBA Wookbook Routines

Does anybody have the order of running event processes when an Excel
Worksheet opens?

I have a data collecttion running when the workbook opens and I want to
review status of an database refresh after a WorkBook opens and gets the
latest data on open. What event process do I use to review data after the
woobbook refresh data from the database? I see events under Woobbook like
Open, Activate, Sheet Activate, Sync, etc... What is the order of these
events in which they activate when you open a sheet?

Thank you in advance fro your help!!!!
Mike


  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
external usenet poster
 
Posts: 857
Default Excel VBA Wookbook Routines

Michael,

Take a look he

http://www.dailydoseofexcel.com/arch...vent-sequence/


--
Hope that helps.

Vergel Adriano


"Michael Kintner" wrote:

Does anybody have the order of running event processes when an Excel
Worksheet opens?

I have a data collecttion running when the workbook opens and I want to
review status of an database refresh after a WorkBook opens and gets the
latest data on open. What event process do I use to review data after the
woobbook refresh data from the database? I see events under Woobbook like
Open, Activate, Sheet Activate, Sync, etc... What is the order of these
events in which they activate when you open a sheet?

Thank you in advance fro your help!!!!
Mike



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
VBA - sub routines Help please Richard Wrigley New Users to Excel 3 November 23rd 06 03:06 AM
VBA routines - help please Richard Wrigley Excel Discussion (Misc queries) 1 November 22nd 06 07:15 PM
Can excel send reminder emails on dates entered in a wookbook? Doubting_her_boss Excel Discussion (Misc queries) 2 October 27th 05 09:33 PM
Excel Statistical Functions and Routines David A. Heiser Excel Worksheet Functions 0 June 3rd 05 05:27 PM
Excel Statistical Functions and Routines David A. Heiser Excel Worksheet Functions 1 June 2nd 05 03:52 AM


All times are GMT +1. The time now is 07:56 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"