Determining the Name of a Caller Macro
Similar to my last question, I would find it very handy to
be able to determine the name of the macro that called the currently executing macro. Is there a VBA function or statement that will do this for me? |
Determining the Name of a Caller Macro
Hi
AFAIK there's no such VBA function. You have to implement this on you own. e.g. add a parameter in your function/procedure call to indicate the calling procedure. -- Regards Frank Kabel Frankfurt, Germany SidBord wrote: Similar to my last question, I would find it very handy to be able to determine the name of the macro that called the currently executing macro. Is there a VBA function or statement that will do this for me? |
Determining the Name of a Caller Macro
Yeah, I've done that . . . just hoping there was a
function. Thanx. -----Original Message----- Hi AFAIK there's no such VBA function. You have to implement this on you own. e.g. add a parameter in your function/procedure call to indicate the calling procedure. -- Regards Frank Kabel Frankfurt, Germany SidBord wrote: Similar to my last question, I would find it very handy to be able to determine the name of the macro that called the currently executing macro. Is there a VBA function or statement that will do this for me? . |
All times are GMT +1. The time now is 11:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com