You can't have a popup display while the file is saving.because
MsgBox and WshShell.Popup are both modal; that is, they halt code
execution until they are replied to. You could create a UserForm,
display it modelessly , save the file then kill the form. This
will work in XL2000 and higher.

MyForm.Show vbModeless
ActiveWorkbook.Save
Unload MyForm


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com






"sungen99"
wrote in
message
...

A little help again please. I need a macro that will

Display a message box saying "Please wait saving files..."

Save the active file (I know how to do this)

Close the message box.

End macro.



Thanks very much.


--
sungen99
------------------------------------------------------------------------
sungen99's Profile:
http://www.excelforum.com/member.php...fo&userid=9144
View this thread:
http://www.excelforum.com/showthread...hreadid=511057