Excel VB: Turn Off Display

  • Thread starter Michael Kintner
  • Start date
M

Michael Kintner

In Excel Vb programming I have a ton of stuff to do behind the scences
(fomatting etc) how can I turn off the display so the screen is not flashing
while I am doing all the fun stuff and then turn back on when finished?

Thank you in advance,
Michael Kintner
 
G

Guest

To freeze the screen"
Application.Screenupdating = FALSE

To restore normal behavior:
Application.Screenupdating = TRUE

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 

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

Turning off display while VBA running 3
Turn screen update off; then back on during macro 3
Turn protection Off... <run code>... turn protection back on 3
Turn display alerts off then back on at close 1
Bold rectangle cursor in VB Editor 3
ScreenUpdating = FALSE 2
Need Excel macro to turn off AutoFormat in a table 2
Turn Off automatic parsing of data in Excel 1

Top