Create a "Please wait...." form
Create a new macro to open that form
Call your existing macro on the form load of that new form
HTH
-Merk
11/25/03 10:29AM
How do I display a message to the screen from within a macro saying"Please wait...." while the macro runs withApplication.Screenupdating=False. I am using Excel 97 & Windows 98?------------------------------------------------~~ Message posted from
http://www.ExcelTip.com/~~View and post usenet messages directly from
http://www.ExcelForum.com/