View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Not visible workbook

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