Excel: How to turn off the macro process steps

[azzi2000]

I have a long macro that keeps on shifting between one sheet select copy.....to another sheet.
I need the process to be invisble to the user and instead place a message msgbox "Please Wait - Processing" until the pocess is done.
Please advice,
Thank you.
Dré

 

[shetlandbob]

launch a message box at the beginning and then at the beginning of you macro use

application.screenupdating = false

and at the end

application.screenupdating = true

It'll run a lot faster to!

 

[azzi2000]

Perfect.
Thank you.

 

[rmikesmith]

Dre,

One caveat if you are displaying a dialog with ScreenUpdating set to False: If the user clicks and drags the dialog around, they will see multiple images of the dialog, since the underlying screen isn't being redrawn. If your macro is primarily copying from one sheet, switching to another, then pasting, you might want to try something like the following, which doesn't switch worksheets, instead of setting ScreenUpdating=False:

Worksheets("Sheet1").Range("A1").Copy Destination:=Worksheets("Sheet2").Range("B1")

Regards,
Mike

 

[azzi2000]

Thank you
Dré