Not visible workbook

  • Thread starter Thread starter Mircea Pleteriu
  • Start date Start date
M

Mircea Pleteriu

Hi,

I need to open two workbooks and one of them to should not be visible.
How to make one of the workbook visible and the other one not visible?

Thanks,
Mircea
 
Windows("Book1.xls").Visible = True
Windows("Book2.xls").Visible = False
 
Mircea,

Open first workbook (the one that shouldn't be visible), then use

ActiveWindow.Visible = False

then open your second visible workbook.

HTH,
Bernie
MS Excel MVP
 
Thanks a lot,

Bernie Deitrick said:
Mircea,

Open first workbook (the one that shouldn't be visible), then use

ActiveWindow.Visible = False

then open your second visible workbook.

HTH,
Bernie
MS Excel MVP
Click to expand...
 
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

Copy Visible Cells and paste in another workbook visible cells only 5
Separating Workbooks 4
Can't make Monthview visible 0
Why do charts disappear? 2
Problem with ".Visible" sheet property 2
Lost view of Application 2
Is there a command to 'Hide' the Activeworkbook? 1
Addin not allowing thisworkbook.save in before save event 3

Back
Top