View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default Hide, not close, one workbook

Hi Ed,

Something like

windows("Book2").Visible=False

--
HTH

Bob Phillips

"Ed" wrote in message
...
I have three workbooks open. I'd like to set an object to one of them so

I
can hide it away from the user, but still have it available for VBA to

write
to it. As far as I can tell, I have to use Application.Window, but I

can't
figure out how to set an object to one particular window to manipulate it.
Hints and suggestions are greatly appreciated.

Ed