"Jeff" wrote in message
...
If I have a macro that, for example, does 10 things. How can I prevent
the
user from seeing the macro whip through the worksheet doing all 10 things?
In access there is a SetWarnings property. Is there something similar in
Excel?

I use:

Application.ScreenUpdating = False

at the start of each "action" sub then the opposite at the end. This freezes
the image on the screen until it's finished running. Excel will show
msgbox's whilst screenupdating is disabled but if the user moves the message
box it makes the screen look wierd.