Guys Thanks for your help!

"Tim Williams" wrote:

activate or unhide a "please wait" sheet

application.screenupdating=false
'do stuff
application.screenupdating=true

re-hide "Please wait" sheet


Tim.

"KenL" wrote in message
...
I'm sure this has been answered before, but nevertheless I need a
little help.
I have created a pretty big spreadsheet and when I run one of the
macros it
goes to many sheets and does a lot of cutting and pasting .
I would like to create a macro that stops the screen from showing
all the
other movements and just display a single screen, maybe even putting
a pop up
message that says "Report Reformmating. Please Wait"
anyone able to help?
Thanks