How to "freeze" the display while a macro is running

Not quite sure if this is what you mean, but to stop the screen from "flickering" when running a macro, include the following line:
Application.ScreenUpdating = False

This not only preserves your eyesight (and sanity) when running macros that move about and between worksheets, but also makes the macro run faster as well.