Hide macros working in the background

[cmazur71]

I have several macros in my excel file...when the macros run, the screen flickers, data is copied/deleted, etc....it's very busy
Is there a way to hide the work being done by the macro and instead display a message "please wait while your data is being created..."

 

[Michael M]

You can speed up the macro AND stop the flickering by adding the lines to all of you macros
You could also post the codes here and someone may assist in speeding them up

sub Name
Application.screenupdating=false
""""yourcode in here
application.screenupdating=true
end sub

If you want a message to appear while the macro is running, you would need to apply it to the status bar