how do I turn the screen off during macro execution

R

redondo

There a way to turn off the screen when macros are executing so you can't see
the macro running and then turn the screen on to display the results when the
macro has completed. I can't figure out how to do this in excel 2007.
 
L

L. Howard Kittle

I don't have 2007 but I think this will work.

Application.ScreenUpdating = False
'your code
Application.ScreenUpdating = True

HTH
Regards,
Howard
 
G

Gord Dibben

See Howard's reply for turning off the jumping around.

If your code is written properly there may no need for jumping around.

Get rid of "selects" and "activates" as much as possible.

Example from macro recorder.......

Range("A1:A19").Select
Selection.Copy
Sheets("Sheet1").Select 'or Activate
Range("A7").Select
ActiveSheet.Paste

Can be written as...........

Range("A1:A19").Copy Sheets("Sheet1").Range("A7")


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell selection - turn it off 1
supress display during execution of an excel macro 3
Turn screen update off; then back on during macro 3
Excel TWO Instances of Excel One watching Other 3
Disable screen refresh during long macro execution 2
Turn Auto recalculation off during macro execution 4
Detecting Calc On or Off 5
Prevent freezing during macro execution? 1

Top