To switch off the screen updating place the following line at the start
of your sub with its counterpart as the last line of your sub.

Application.ScreenUpdating = False
...
Application.ScreenUpdating = True

HTH:)