Application.OnTIme
You can do that too. But you need to add a call on the Workbook_Open event in
order to call the procedure. Then you can use another onTime to close the
workbook after a few seconds.
Have a look at ExcelTip for the code on how to unload the workbook after the
time has elapsed.
Robert
|