Not sure if this is what you are looking for, but you can switch off
Screen updating:

Application.ScreenUpdating = False

Hope that helps.

Remy Blaettler
www.collaboral.com