hide a macro's movement while running the macro

Question

hide a macro's movement while running the macro

Anonymous

How do I hide the movement/screen jumping around while a macro is running? In other words I have a macro thet goes to different cells and pages while running and I see all this when it is running. How do I stop/hide all the jumping around on my PC screen when a macro is running?

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

4 additional answers

Answer 1

Add this to your code near start.

With Application

.ScreenUpdating = False

.Calculation = xlManual

End With

do all the stuff with no jumping around or waiting for calcs

then reset it at end

With Application

.Calculation = xlAutomatic

.ScreenUpdating = True

End With

Gord

Answer 2

You can use the ScreenUpdating property, like this:

Application.ScreenUpdating = False

'Your code

Application.ScreenUpdating = True

When you set ScreenUpdating to False the screen will not update while the code is running. Just remember to always set it back to True when you are done.

tod

Answer 3

Anonymous

Thank tod this is exactly what I needed. It worked well. Also Gord answered me too and you don't need the "Application." part of your answer but it workes with it attached anyway. Just moer typing to do is all. Thanks again.

0 comments

Answer 4

Anonymous

Hi Gord,

Is rather dangerous when not error handler is foreseen.

Wkr,

JP Ronse

0 comments

Answer 5

Anonymous

Thank Gord this is exactly what I needed. It worked perfectly.

0 comments

Share via

hide a macro's movement while running the macro

4 additional answers