Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Learning about the ScrenUpdating property of the Excel application
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Learning about the ScrenUpdating property of the Excel application
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. -- Regards, Tom Ogilvy "Almamba" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Learning Excel | New Users to Excel | |||
Learning VB for Excel | New Users to Excel | |||
Learning excel | Charts and Charting in Excel | |||
Learning how to use Excel | Excel Discussion (Misc queries) | |||
Error Setting Excel's Application.Left Property | Excel Programming |