Excel VB: Turn Off Display

[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

 

[Keith74]

Application.ScreenUpdating = False

and switch to true when finished.

hth

Keith

 

[Ron Coderre]

To freeze the screen"
Application.Screenupdating = FALSE

To restore normal behavior:
Application.Screenupdating = TRUE

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

XL2002, WinXP