windows for experts

M

Mark

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
 
B

Bob Phillips

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)
 
Top