Excel macro - screen while macro runs

When I run my macro is can see it switching sheets and copy/pasting data. But this isn't really user-friendly. Is there a way to show a simple mes开发者_如何学JAVAsagebox "The macro is running!" for the entire duration and OK only becomes clickable when the macro stops?

Thank you!

In your code use:

Application.ScreenUpdating = False

//Your code

Application.ScreenUpdating = True

This will stop the screen flicker you are seeing...