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,
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,
You are quite correct. try this:
application.screenupdating=false
'
'your code here
'
application.screenupdating=true
"Bharath Rajamani" <[email protected]> wrote in
message news:[email protected]...
> 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,
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,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks