SO it is not possible to auto run the macro and receive a
prompt saying the marco is running?
-----Original Message-----
Hi wendy,

The macro will not start until [OK] button is clicked in
the message
box.
So I think using an userform is better in your case.
Please have a look @ attached sample file.

Attachment filename:
book1.xls
Download attachment:
http://www.excelforum.com/attachment.php?postid=401942
---
Message posted from http://www.ExcelForum.com/

.