Posted to microsoft.public.excel.programming
|
|
Fetching a VBA Macro's Name During Execution
Hi
AFAIK this is not possible
--
Regards
Frank Kabel
Frankfurt, Germany
SidBord wrote:
In all the macros I write, I put the name of the macro in
the title bar of all Msgbox and Inputbox msgs I generate.
Is there a VBA statement that will fetch the name of the
macro that is executing so I don't have to hard code the
macro name into my msgs? I want something like the code
that fetches the worksheet name that is currently active.
|