ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   OnTime event not firing in Workbook_Open event procedure (https://www.excelbanter.com/excel-programming/277895-ontime-event-not-firing-workbook_open-event-procedure.html)

GingerTommy

OnTime event not firing in Workbook_Open event procedure
 
I am experiencing a problem with Excel 97 and OnTime.

I have placed the following code in a Workbook_Open event procedu

Debug.Print "Workbook_Open"
Application.OnTime Now() + TimeValue("00:00:01"), "MShared.Main"

When I open the workbook the file menu, or by double-clicking in file
explorer, the Workbook_Open code and the OnTime macro fires as
expected.
The problem comes when I open the workbook using:

Workbooks.Open "F:\CMT\CMT.xla"

The Workbook_Open event fires (I know this because the debug statement
is run) but the OnTime procedure never gets called.

I have tried increasing the interval for the OnTime to 5 seconds,
still no joy.
Has anyone experienced this behaviour before? Any resolutions?

TIA, Thomas.


All times are GMT +1. The time now is 06:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com