I have a macro that takes about 4 hours to run, and I run
it on an XP machine across the room from me. I can stand
up from my desk to glance at it and see what stage it's up
to (The macro highlights cells after every completed
procedure on a 'homepage' to indicate progress).

The problem: The computer doesn't realize that activity
is happening, and switches to screensaver after a few
minutes, then locks, and I can't just stand up and see
what stage it's up to. In 97, Excel seems to stay in
view. Is there something I can do in the code to keep
Excel on view in XP (besides turning screenupdating to
True)? Or a setting in Excel?

Thanks for any suggestions

Dare I suggest you turn your screen saver off via Windows' Display
Properties?<g

--
Jim Rech
Excel MVP

well, maybe i didnt understand... but can't you just
disable the screensaver from control panel??

-----Original Message-----
I have a macro that takes about 4 hours to run, and I run
it on an XP machine across the room from me. I can stand
up from my desk to glance at it and see what stage it's
up
to (The macro highlights cells after every completed
procedure on a 'homepage' to indicate progress).

The problem: The computer doesn't realize that activity
is happening, and switches to screensaver after a few
minutes, then locks, and I can't just stand up and see
what stage it's up to. In 97, Excel seems to stay in
view. Is there something I can do in the code to keep
Excel on view in XP (besides turning screenupdating to
True)? Or a setting in Excel?

Thanks for any suggestions

.

How embarassing. My apologies for my question.
I have never stepped outside the world of Excel, and did
not know that such things are possible.
Must get out more.


-----Original Message-----
Dare I suggest you turn your screen saver off via
Windows' Display
Properties?<g

--
Jim Rech
Excel MVP


.