View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Wilson John Wilson is offline
external usenet poster
 
Posts: 550
Default Screen off during Macro execution


"CLR" wrote in message
...
Many thanks to all who responded.

I guess that's what makes these newsgroups so wonderful, is that you can
ask a simple question, and get back several different approaches to the
problem. Then you can choose the one that is the easiest for you to
understand and implement. Indeed, Auk Ales first response worked just

fine
for me in my Win98SE-XL2k situation. Thanks for the compliment John, but
I'm sorry to disappoint you. I was not familiar with it, as I'm just
getting in to this code stuff.
I'm still at the "editing recorded macros, and copying other peeps code"
stage. <g

I will later look in to the other comments and suggestions......they will
certainly help my learning process.

Merry Christmas to everyone........

Vaya con Dios,
Chuck, CABGx3






"CLR" wrote in message
...
Hi All......

With you fine folks help, I've managed to put together a nifty macro

that
does what I want it to do. The only thing now is, during it's executon

the
macro jumps back and forth between screens and this causes each one to

flash
up on the monitor and I would prefer that they not do that.........any

way
to "turn off the display at the beginning of the macro and turn it back

on
again at the end"......??......or better yet, to put up some "Please

wait"
message during processing.......

TIA
Vaya con Dios,
Chuck, CABGx3