Have a look the Caller property in help. If the Caller
is "An Auto_Open, Auto_Close, Auto_Activate, or
Auto_Deactivate macro" you could make the
activewindow.visible property false.
Geof.
-----Original 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?
action=getinfo&userid=6708
View this thread:
http://www.excelforum.com/showthread...hreadid=266818

.