Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |