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 |
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 |
All times are GMT +1. The time now is 10:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com