Excel VB: Turn Off Display
 

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

Excel VB: Turn Off Display
 

Application.ScreenUpdating = False

and switch to true when finished.

hth

Keith

Excel VB: Turn Off Display
 

To freeze the screen"
Application.Screenupdating = FALSE

To restore normal behavior:
Application.Screenupdating = TRUE

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

XL2002, WinXP


"Michael Kintner" wrote:

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