Unusual question

  • Thread starter Thread starter Daniel Bonallack
  • Start date Start date
D

Daniel Bonallack

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
 
well, maybe i didnt understand... but can't you just
disable the screensaver from control panel??
 
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.
 
Back
Top