LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to hide workbook in background...

Hi,
I'm working with two workbooks. One has my macros the other has the data. I
assume in order to access the data in the data workbook it has to be open.
That said, is there a way I can hide the data workbook without first making
it active and then using ActiveWindow.Visible = False? I'd also like to make
it Visible again before I close it but not have to Activate it before doing
so.

Basically I want to make the opening of the data file as transparent to the
user as I can.

Thanks very, very much!
bd

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Color Background cells in workbook Diggsy Excel Programming 2 August 23rd 05 10:06 PM
Open a workbook in the background (like filestream) TommySzalapski[_8_] Excel Programming 1 July 26th 05 03:17 PM
Opening a Workbook in the Background g-boy Excel Programming 6 May 20th 05 04:26 PM
How to hide a process in the background? buckle Excel Programming 1 October 26th 04 11:34 PM
How to hide a workbook and to detect a hidden workbook in visual basic jn1971[_3_] Excel Programming 0 May 5th 04 10:08 PM


All times are GMT +1. The time now is 02:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"