If you put that code in each macro, then you know the macro name. Just
include it in the message.



--
Regards,
Tom Ogilvy

"Ken Loomis" wrote in message
...
Is there a way to get the current macro name?

I'd like to add some code at the beginning of each macro like this:

If debugOn Then
MsgBox ("Entering" & activeMacro)
End If

and replace 'activeMacro' with whatever will return the name of the
currently executing macro. And use a public variable, "debugOn," to turn
that message box display on or off.

Thanks,
Ken Loomis