Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning off Screen Refresh
Is there any way to turn off screen refresh while running
a program in VB? Sullivan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning off Screen Refresh
A VERY often asked question. Did you try the archives first?
"sullivan" wrote in message ... Is there any way to turn off screen refresh while running a program in VB? Sullivan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning off Screen Refresh
Sullivan,
Application.screenupdating=false .... code here ... Application.screenupdating=true Cheers, Pete -----Original Message----- Is there any way to turn off screen refresh while running a program in VB? Sullivan . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning off Screen Refresh
' turn it off
Application.ScreenUpdating = False ' turn it back on Application.ScreenUpdating = True -- Regards, Tom Ogilvy "sullivan" wrote in message ... Is there any way to turn off screen refresh while running a program in VB? Sullivan |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning off Screen Refresh
Sullivan,
Use something like the following: Application.ScreenUpdating = False ' your code here Application.ScreenUpdating = True -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "sullivan" wrote in message ... Is there any way to turn off screen refresh while running a program in VB? Sullivan |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning off Screen Refresh
You might want to put this in a class module as follows.
Add a a class module and name it SuspendRefresh. The code is: Option Explicit Private Sub Class_Initialize() Application.ScreenUpdating = False End Sub Private Sub Class_Terminate() Application.ScreenUpdating = True End Sub ' End of class module In your sub or function, do the following Sub DemoScreenUpdateClass() dim su as SuspendRefresh ' when ready to suspend the screen refresh set su = new SuspendRefresh ' when ready to resume screen refresh set su = Nothing ' if you don't want to resume screen refresh until the Sub or Function ends, do nothing. VBA will ' automatically perform the "set su = Nothing" for you on Exit Sub or Exit Function End Sub Mike. "Chip Pearson" wrote in message ... Sullivan, Use something like the following: Application.ScreenUpdating = False ' your code here Application.ScreenUpdating = True -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "sullivan" wrote in message ... Is there any way to turn off screen refresh while running a program in VB? Sullivan |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning off Screen Refresh
Application.ScreenUpdating = False
Your Macro Application.ScreenUpdating = True "sullivan" wrote in message ... Is there any way to turn off screen refresh while running a program in VB? Sullivan |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turning off Screen Refresh
Sullivan,
I think you are looking for the application.screenupdating=false command. Best regards, Kevin "sullivan" wrote in message ... Is there any way to turn off screen refresh while running a program in VB? Sullivan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Screen Refresh | Excel Discussion (Misc queries) | |||
Screen refresh problem. | Excel Programming | |||
Screen refresh problem. | Excel Programming | |||
Screen Refresh after minimize | Excel Programming | |||
Turning off all screen updates during a Solver routine | Excel Programming |