Macro - Prevent screen refresh
 

Is there a way to prevent the workbook screen display getting refreshed as a
macro runs, and make the macro run in the background without refreshing the
worksheet display.

Maybe it runs faster that way.


Rgds,

Macro - Prevent screen refresh
 

You are quite correct. try this:

application.screenupdating=false
'
'your code here
'
application.screenupdating=true

"Bharath Rajamani" wrote in
message ...
Is there a way to prevent the workbook screen display getting refreshed as
a
macro runs, and make the macro run in the background without refreshing
the
worksheet display.

Maybe it runs faster that way.


Rgds,

Macro - Prevent screen refresh
 

Bharath:

Application.ScreenUpdating = False
'...
'Your code in Here
'...
Application.ScreenUpdating = True



HTH
Duncan


Bharath Rajamani wrote:
Is there a way to prevent the workbook screen display getting refreshed as a
macro runs, and make the macro run in the background without refreshing the
worksheet display.

Maybe it runs faster that way.


Rgds,