View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
g-boy g-boy is offline
external usenet poster
 
Posts: 5
Default Opening a Workbook in the Background

"STEVE BELL" wrote:
Enclosing your code with:

Application.Screenupdating = False
[code]
Application.Screenupdating = True

This prevents the screen from being updated and the user will not see what
is happening. This also speeds up the process.


Wow... this is interesting, and I didn't know about it. So thank you for
the tip.

However, in this particular case, I would like (if possible) to be able to
LEAVE the workbook open in the background, so I can reference it "on demand"
as it were with scripts, but I would like it to be invisible.

The screenupdating thing doesn't fly for this, because I would like the user
to be able to do things and interact with the "front end" workbook, while the
data workbook is open (but hidden).

Any thoughts?