yep you can turn off the updating

put the following at the beginning of your code

Application.ScreenUpdating = False
there is no need to set it to true as this is done automatically when macro
finishes.

you may also want to use the following if your spreadsheets contain lots of
formulas

application.Calculation = xlCalculationManual
this stops excel recalculating formulas each time it changes something -
however you do need to set this back to automatic at the end of the macro

application.Calculation = xlCalculationAutomatic