I want to close down excel after 1 hour automatically
 

I would like to close down excel after 1 hour automatically once it has
been started: I have tried some timer loops, this does work, but has
some side-effects. I had placed the loop into the workbook.activate
respectively in the workbook.open routines, but its not the roght place
there. Can it be done, elsewhere, or is there any other solution?


--
blitzz
------------------------------------------------------------------------
blitzz's Profile: http://www.excelforum.com/member.php...o&userid=34078
View this thread: http://www.excelforum.com/showthread...hreadid=538408

I want to close down excel after 1 hour automatically
 

Look at Application.OnTime

http://www.cpearson.com/excel/ontime.htm

--
Regards,
Tom Ogilvy


"blitzz" wrote:


I would like to close down excel after 1 hour automatically once it has
been started: I have tried some timer loops, this does work, but has
some side-effects. I had placed the loop into the workbook.activate
respectively in the workbook.open routines, but its not the roght place
there. Can it be done, elsewhere, or is there any other solution?


--
blitzz
------------------------------------------------------------------------
blitzz's Profile: http://www.excelforum.com/member.php...o&userid=34078
View this thread: http://www.excelforum.com/showthread...hreadid=538408

I want to close down excel after 1 hour automatically
 

Problem solved, Tom, I am most grateful. It is good to have control....


--
blitzz
------------------------------------------------------------------------
blitzz's Profile: http://www.excelforum.com/member.php...o&userid=34078
View this thread: http://www.excelforum.com/showthread...hreadid=538408