View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel Bonallack[_2_] Daniel Bonallack[_2_] is offline
external usenet poster
 
Posts: 27
Default Unusual question

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