View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Keeping a workbook hidden when opened via VBA???

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.



--
Regards,
Tom Ogilvy

"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