LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 95
Default what do You say? :)

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"