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

--
Regards,
Tom Ogilvy

"Mircea Pleteriu" wrote in message
...
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

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

"Mircea Pleteriu" wrote in message
...
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

Thanks a lot,

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
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

"Mircea Pleteriu" wrote in message
...
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