ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Test if macro is called by another macro (https://www.excelbanter.com/excel-programming/413050-test-if-macro-called-another-macro.html)

DaveM[_2_]

Test if macro is called by another macro
 
Hi

I have a lot of code and was looking at my macros and saw one that needs to
be run.
Rather than going though all the code to check this, I was wondering if
there is any way I could test if this macro is called by another macro?

Just a thought

Thanks in advance

Dave



Bob Phillips

Test if macro is called by another macro
 
Do a Ctrl-F and go hunt it.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"DaveM" wrote in message
. uk...
Hi

I have a lot of code and was looking at my macros and saw one that needs
to be run.
Rather than going though all the code to check this, I was wondering if
there is any way I could test if this macro is called by another macro?

Just a thought

Thanks in advance

Dave




Susan

Test if macro is called by another macro
 
if you use the coding "Call MyOtherSub" generally, just search the
whole project for that string in the find/edit/replace area of the VB
editor (in the toolbar under "Edit").
susan


On Jun 24, 10:10*am, "DaveM" wrote:
Hi

I have a lot of code and was looking at my macros and saw one that needs to
be run.
Rather than going though all the code to check this, I was wondering if
there is any way I could test if this macro is called by another macro?

Just a thought

Thanks in advance

Dave



DaveM[_2_]

Test if macro is called by another macro
 
Thanks Bob, Susan




"Susan" wrote in message
...
if you use the coding "Call MyOtherSub" generally, just search the
whole project for that string in the find/edit/replace area of the VB
editor (in the toolbar under "Edit").
susan


On Jun 24, 10:10 am, "DaveM" wrote:
Hi

I have a lot of code and was looking at my macros and saw one that needs
to
be run.
Rather than going though all the code to check this, I was wondering if
there is any way I could test if this macro is called by another macro?

Just a thought

Thanks in advance

Dave





All times are GMT +1. The time now is 12:41 PM.

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