windows for experts

  • Thread starter Thread starter Mark
  • Start date Start date
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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with ActiveWorkbook.Close command 3
Application.Quit 1
Check for other open wokbooks 7
what do You say? :) 4
Code to Quit App Doesn't Work 2
How can I force a workbook to close? 6
Unwanted workbooks on startup 2
Closing Excel When Using CreateObject to Open It 2

Back
Top