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
 
R

Ron Coderre

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

Top