Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
windows for experts
Hi,
There is following problem: I've open two or more workbooks in two or more windows (Excel). I'd like close one workbook with one excel's window. If i use ActiveWorkbook.Close - workbook close but excel's window still remain.. ,and code application.quit close all opened workbooks and excel's windows... :) How can I make progress with close window? Thank for any help! Regards Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
windows for experts
Mark,
Not sure what you want so this is a guess Application.WindowState = xlMinimized -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Mark" wrote in message ... Hi, There is following problem: I've open two or more workbooks in two or more windows (Excel). I'd like close one workbook with one excel's window. If i use ActiveWorkbook.Close - workbook close but excel's window still remain.. ,and code application.quit close all opened workbooks and excel's windows... :) How can I make progress with close window? Thank for any help! Regards Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ALL EXPERTS ........... WHERE ARE YOU ?? | Excel Discussion (Misc queries) | |||
for the experts | Excel Discussion (Misc queries) | |||
again for the experts | Excel Discussion (Misc queries) | |||
Help - Need experts help! | Excel Discussion (Misc queries) | |||
another for the experts | Excel Discussion (Misc queries) |