At the beginning of each macro put the following

Application.ScreenUpdating = False

At the End put

Application.ScreenUpdating = True



This will allow the computer to work on the calculations without having to update the screen with each calculation. This is very handy when switching from sheet to sheet and then some.