macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Ken
Just add this to the top of your macro

Application.ScreenUpdating=False
and perhaps
Application.StatusBar="Report Reformmating. Please Wait"
 
activate or unhide a "please wait" sheet

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

re-hide "Please wait" sheet


Tim.
 
Guys Thanks for your help!

Tim Williams said:
activate or unhide a "please wait" sheet

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

re-hide "Please wait" sheet


Tim.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to generate powerpoint slides 43
Need help with simple macros for double checking manual plugs 4
Run two macros for two different sheets 11
Macro Related to Paste Values 2
Run Macro on All Sheets Q 8
Copy and paste sheets to new workbook 14
Working of formula in Macro. 1
Macro to copy A1 tp J(bottom) 1

Back
Top