Learning about the ScrenUpdating property of the Excel application

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

property I will appreciate it if anyone can help me to learn about the
ScreenUpdating property of the Excel application. Specifically, I would like
somebody to help me to enter Visual Basic statements that turn the
ScreenUpdating
property of the application object to FALSE to turn off screen updating and
TRUE to turn screen updating back on. I am working on a macro in Excel 2000.

Thank you very much in advance.
 
Application.ScreenUpdating = False
' it is now off


Application.ScreenUpdating = True
' it is now on

Look up ScreenUpdating in Excel VBA help for a written explanation.
 
You must log in or register to reply here.

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

Worksheet_Change Woes 6
Merge data from sharepoint workbooks 1
Found where program stops, but can't stop it stopping !! 3
Newb: Asking about a tweak in code 2
Listbox displaying incorrectly on opening worksheet 3
deleting blank rows for up to 60000 rows of data 3
Stay on Active Sheet 2
Weird screen refresh problem in Excel 2003 - bits of differentworksheets display. 5

Back
Top