application.screenupdating = false

at the start of the macro, and

application.screenupdating = true

at the end of the macro