Excel VB: Turn Off Display

  • Thread starter Thread starter Michael Kintner
  • Start date 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
 
To freeze the screen"
Application.Screenupdating = FALSE

To restore normal behavior:
Application.Screenupdating = TRUE

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

XL2002, WinXP
 
Back
Top