Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling a specific macro
I have a procedure (procedure A) that calls a macro (Macro A). I need
Procedure B to run Procedure A but to skip Macro A. Possible????? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling a specific macro
Matt,
Here is one way... '------------------------- Sub ProcA(Optional Arg As Boolean = True) MsgBox "ProcA started" If Arg Then Call DoSomething End Sub Function DoSomething() MsgBox "Function DoSomething started" End Function Sub ProcB() MsgBox "ProcB started" Call ProcA(False) End Sub Sub StartItUp() Call ProcA Call ProcB End Sub '------------------ Jim Cone San Francisco, USA "Matt" wrote in message I have a procedure (procedure A) that calls a macro (Macro A). I need Procedure B to run Procedure A but to skip Macro A. Possible????? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling a specific macro
Jim: I appreciate the code, but this doesn't achieve what I am looking for.
"Jim Cone" wrote: Matt, Here is one way... '------------------------- Sub ProcA(Optional Arg As Boolean = True) MsgBox "ProcA started" If Arg Then Call DoSomething End Sub Function DoSomething() MsgBox "Function DoSomething started" End Function Sub ProcB() MsgBox "ProcB started" Call ProcA(False) End Sub Sub StartItUp() Call ProcA Call ProcB End Sub '------------------ Jim Cone San Francisco, USA "Matt" wrote in message I have a procedure (procedure A) that calls a macro (Macro A). I need Procedure B to run Procedure A but to skip Macro A. Possible????? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling a specific macro
Matt,
Am I supposed to guess? Jim Cone "Matt" wrote in message ... Jim: I appreciate the code, but this doesn't achieve what I am looking for. "Jim Cone" wrote: Matt, Here is one way... '------------------------- Sub ProcA(Optional Arg As Boolean = True) MsgBox "ProcA started" If Arg Then Call DoSomething End Sub Function DoSomething() MsgBox "Function DoSomething started" End Function Sub ProcB() MsgBox "ProcB started" Call ProcA(False) End Sub Sub StartItUp() Call ProcA Call ProcB End Sub '------------------ Jim Cone San Francisco, USA "Matt" wrote in message I have a procedure (procedure A) that calls a macro (Macro A). I need Procedure B to run Procedure A but to skip Macro A. Possible????? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disabling Macro Warning | Excel Discussion (Misc queries) | |||
Disabling an 'on load' macro | Excel Worksheet Functions | |||
Disabling Macro-Virus check | Excel Programming | |||
Disabling Macro-Virus check | Excel Programming | |||
Disabling Saveas and saving file with a specific name only | Excel Programming |