run macros in background

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My macros involve a lot of copying pages, reformatting, adding formulas,
plotting, etc.
When a macro runs, it can take several seconds. Meanwhile you are watching
Excel go through all sorts of contortions as things are happening.

Is there anyway to cause either:
1) the screen to effectively "freeze" until the macro is complete,
or
2) go blank or some other less stressful appearance until the macros are
done running?

TIA
 
Hi

use
Application.ScreenUpdating = False
at the top of your code and
Application.ScreenUpdating = True
at the bottom

Cheers
JulieD
 
You must log in or register to reply here.

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

Run macro in background 3
Background copy macro 8
Message while macro is executing 3
copy and paste 3 rows run macro and continue to end of columns 1
Macro Runs Twice 3
Macros: Why 'wbook.xls'!MyMacro 4
Skip part of macro on re-run? 1
How to run auto-open macro in Excel 2007? 3

Back
Top