ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro Names (https://www.excelbanter.com/excel-programming/305155-macro-names.html)

Douglas[_3_]

Macro Names
 
This follwoing command will open the Macro Dialog Box ;
and because it says Wait:=False it will continue to the
next line of code ....

Application.SendKeys Keys:="%tmm", Wait:=False

Question: Is there a command that I can use in the next
line of the macro that will return the Macro Name field of
the current macro selected in the Macro Dialog Box so that
I can test it to see if it is the one I am looking for?

Thank you for your help.

Steven


Tom Ogilvy

Macro Names
 
To the best of my knowledge, there is no built in support for this.

--
Regards,
Tom Ogilvy

"Douglas" wrote in message
...
This follwoing command will open the Macro Dialog Box ;
and because it says Wait:=False it will continue to the
next line of code ....

Application.SendKeys Keys:="%tmm", Wait:=False

Question: Is there a command that I can use in the next
line of the macro that will return the Macro Name field of
the current macro selected in the Macro Dialog Box so that
I can test it to see if it is the one I am looking for?

Thank you for your help.

Steven





All times are GMT +1. The time now is 04:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com