If you used MsgBox to show your message, the macro will halt and wait for user interaction. You can show a form with a progres bar-- overkill, I think

I would show the message on the application.status bar (help file) and turn the mouse pointer to an hourglass.