Macro Pause, show message, continue

I am working on a macro that moves through 64 folders, looks for a
particular spreadsheet in the folder, opens the spreadsheet for
editing, then closes it when I'm finished editing.
If the spreadsheet isn't there, I'd like it to display a short message
for a few seconds, like "Spreadsheet.xls Not Found", then goes on to
the next folder.
Is there a way to pause the macro, show the message for 2 or 3 seconds,
then continue?
TIA

this should be of some help.
http://tinyurl.com/586ga
--
Don Guillett
SalesAid Software
[email protected]
"davegb" <[email protected]> wrote in message
news:[email protected]...
> I am working on a macro that moves through 64 folders, looks for a
> particular spreadsheet in the folder, opens the spreadsheet for
> editing, then closes it when I'm finished editing.
> If the spreadsheet isn't there, I'd like it to display a short message
> for a few seconds, like "Spreadsheet.xls Not Found", then goes on to
> the next folder.
> Is there a way to pause the macro, show the message for 2 or 3 seconds,
> then continue?
> TIA
>

Thanks, Don. Didn't know about that NG.

glad to help

--
Don Guillett
SalesAid Software
[email protected]
"davegb" <[email protected]> wrote in message
news:[email protected]...
> Thanks, Don. Didn't know about that NG.
>