Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable screen refreshes
I recall seeing a way of disabling updates to the Excel application window
temporarily while a macro runs, so as to improve the efficiency of running macro. Only, I can't recall what the function was that accomplished this. Can anyone point me in the right direction? Thanks, Y |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable screen refreshes
Hi Ybazizi,
Try: Application.ScreenUpdating = False 'Your code Application.ScreenUpdating = False --- Regards, Norman "ybazizi" wrote in message ... I recall seeing a way of disabling updates to the Excel application window temporarily while a macro runs, so as to improve the efficiency of running macro. Only, I can't recall what the function was that accomplished this. Can anyone point me in the right direction? Thanks, Y |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable screen refreshes
application.screenupdating = false
'your code application.screenupdating = true -- HTH... Jim Thomlinson "ybazizi" wrote: I recall seeing a way of disabling updates to the Excel application window temporarily while a macro runs, so as to improve the efficiency of running macro. Only, I can't recall what the function was that accomplished this. Can anyone point me in the right direction? Thanks, Y |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable screen refreshes
Hi Ybazizi,
The last line should read: Application.ScreenUpdating = True --- Regards, Norman "Norman Jones" wrote in message ... Hi Ybazizi, Try: Application.ScreenUpdating = False 'Your code Application.ScreenUpdating = False --- Regards, Norman "ybazizi" wrote in message ... I recall seeing a way of disabling updates to the Excel application window temporarily while a macro runs, so as to improve the efficiency of running macro. Only, I can't recall what the function was that accomplished this. Can anyone point me in the right direction? Thanks, Y |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to disable screen saver | Excel Programming | |||
Disable Splash Screen | Excel Programming | |||
Disable Print Screen Round 2 . . . | Excel Programming | |||
Disable Print Screen Challenge | Excel Programming | |||
How does one refreshes the screen? | Excel Programming |