View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
yo yo is offline
external usenet poster
 
Posts: 1
Default Unusual question

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

.