Will they be impressed as much when they have a fit?


Bob


"Judy Ward" wrote in message
...
Thank you very much for your reply. I was only using this in my borrowed
function; I can see that it would be a good idea to use it throughout my
macros--except that my users are impressed by seeing the screen movements!

Thank you,
Judy

"Dave Peterson" wrote:

If your code changes worksheets or moves the screen (going to other
cells), then
it hides those screen movements.

It's less disturbing to the user and actually makes your code work
faster.



Judy Ward wrote:

I have "borrowed" subroutines from this site (that work beautifully)
that have:

ScreenUpdating = False
<code that changes the values of cells here
ScreenUpdating = True

I was wondering what setting the ScreenUpdating to false and back to
true is
doing for me. I looked in Excel help (it was no help).

I would love a simple (I'm not an advanced user) explanation.
Thank you,
Judy

--

Dave Peterson