"Please wait" while macro is running?

[chuckles1066]

Any links to the most professional looking one?

I've enough knowledge of VBA now (thanks to you good people and this excellent site) to be able to code a text box etc etc but why reinvent the wheel?

TIA.

 

[VoG]

Try using the status bar

application.statusbar="Macro in progress"
'
'your code
'
application.statusbar=false