Keeping a workbook hidden when opened via VBA???

[Simon Lloyd]

Hi all,

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


Simo

 

[Geof Wyght]

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.

 

[CB Hamlyn]

In the VBA that opens the workbook, simply hide it with:

 

[Tom Ogilvy]

If you open it in VBA, then hide it with the same code. If you don't save
it, then it should be visible next time it is opened.