macros
 

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

macros
 

Ken
Just add this to the top of your macro

Application.ScreenUpdating=False
and perhaps
Application.StatusBar="Report Reformmating. Please Wait"


"KenL" wrote:

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

macros
 

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

macros
 

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