View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ed Ed is offline
external usenet poster
 
Posts: 399
Default Thank you!

Thanks to both of you.

"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