Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Workbook_Open event does not run on Outlook attachment | Excel Discussion (Misc queries) | |||
workbook_Open event Procedure | Excel Discussion (Misc queries) | |||
workbook_Open event Procedure | Excel Discussion (Misc queries) | |||
Workbook_Open() Event | Excel Discussion (Misc queries) | |||
Workbook_Open event not working | Excel Programming |