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?
|