Excel - VBA (Freezing the Display During Maacro Execution)

[Art Fitzgerald]

I have developed a VBA Procedure (macro) for Excel and
would like to freeze the window display while the macro
is executing. Although I'm sure it was possile to freeze
the display on older macros, prior to VBA, I can't seem
to find a way to do it with VBA. Can anyone help?

 

[JulieD]

Hi Art
at the top of your macro
application.screenupdating = false

at the bottom
application.screenupdating = true

Regards
JulieD

 

[JWolf]

Sub YourSub()
Application.ScreenUpdating=False
----your code here----
Application.SreenUpdating=True
End Sub

 

[Tom Ogilvy]

Sub Mycode()
Application.ScreenUpdating = False
' existing code
Application.ScreenUpdating = True
End Sub