Hi;
In two separate workbooks, I have the following:
In the Workbook_Open event:
frmSplash.show
In frmSplash's code:
Application.OnTime Now + TimeValue("00:00:02"), "KillForm"
In a module:
Sub KillForm()
unload frmSplash
End Sub
Again, in one workbook it works beautifully, in another it crashes XL. When I step through everything it works fine, but on a cold open it crashes. I get 'Object invoked has disconnected from one of its clients', runtime error 9, I/O Device Error, Path/File Error, etc. I can recreate it every time - and can only open it now by holding down the SHIFT key while doing so...
But the SAME code works PERFECTLY in a different workbook! I am completely lost here. If anyone has any ideas PLEASE let me know.
(Is there a limit to how many modules or forms one VBAPRoject can have??)
Thanks for ANY help...
Gahagan
This message was edited by Gahagan on 2002-04-06 14:33
In two separate workbooks, I have the following:
In the Workbook_Open event:
frmSplash.show
In frmSplash's code:
Application.OnTime Now + TimeValue("00:00:02"), "KillForm"
In a module:
Sub KillForm()
unload frmSplash
End Sub
Again, in one workbook it works beautifully, in another it crashes XL. When I step through everything it works fine, but on a cold open it crashes. I get 'Object invoked has disconnected from one of its clients', runtime error 9, I/O Device Error, Path/File Error, etc. I can recreate it every time - and can only open it now by holding down the SHIFT key while doing so...
But the SAME code works PERFECTLY in a different workbook! I am completely lost here. If anyone has any ideas PLEASE let me know.
(Is there a limit to how many modules or forms one VBAPRoject can have??)
Thanks for ANY help...
Gahagan
This message was edited by Gahagan on 2002-04-06 14:33