In the VBA that opens the workbook, simply hide it with:
---------------------------------------------------------
ActiveWindow.Visible = False
or
Windows("WorkbookName.xls").Visible = False
---------------------------------------------------------

Then, in the now hidden workbook's close code, do this:
-------------------------------------------------------------
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Windows("WorkbookName.xls").Visible = True
End Sub
-------------------------------------------------------------

Good Luck
CB Hamlyn

"Simon Lloyd" wrote in message
...

Hi all,

Does anyone know how to keep a workbook hidden that is opened via VBA
and visible when opened normally i.e with a double left click or from
choosing File and then Open??


Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=266818