just pointing out a typo in a comment

Ensus(r)e the ActiveProject is not locked.

--


Gary


"Chip Pearson" wrote in message
...
Stu,

There is no built in way for a procedure to get its own name. I have code on
my web site that will insert a const declaration in to every procedure. The
value of the const is the name of the procedure in which it resides. See
www.cpearson.com/excel/InsertProcedureNames.aspx . You can then use that const
value in your MsgBox.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)



"Stu W" wrote in message
...
Is there a way to refer to the currently running module and procedure name in
a msgbox?