Hi Rob,
I know method OnTime, i have problem with something else.
(see my first post)
Regards
Mark
-----Original Message-----
Chip Pearson has some good information regarding OnTime:
http://www.cpearson.com/excel/ontime.htm
--
Rob van Gelder - http://www.vangelder.co.nz/excel
"Mark" wrote in message
...
I use method OnTime and before close workbook I switch
schedule to False - I want bring to end some routine.
When I work in Thisworkbook i've open another workbook
in
different windows, which i'd like remain it after
Thisworkbook close.
Code ActiveWorkbook.Close produce Window application
(excel) isn't close and method OnTime still work though
schedule is False ???!!!
When i wrote:
Application.Quit OnTime ... schedule:False work, but vba
close all windows with remain workbook but i don't want
it.
How close only window with activeworkbook and remain
another application(excel) with another workbook.
Any help (code) will be appreciate.
Regards
Mark
.