One way where you use a textbox that says "My macro is running, pls be
patient"

Sub showmsg()
With Sheets("sheet6")
..Shapes("Text Box 3").Visible = True
'your code here
..Shapes("Text Box 3").Visible = False
End With
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Greg H." wrote in message
...
Is there a way I can display a message while a macro runs in the
background?
I want to let users know to wait until the macro finishes. I tried the
msgbox command but the macro will not run until you press ok and I want it
to
stay open until the macro finishes. Any ideas?