Can I disable a module?

[djl0525]

I am collecting modules in one workbook so that I can refer to them in one place in the future, but I don't want each module to run every time I open the workbook. I may want some to run, but not all of them. Is there a way to disable a module other than commenting one line at a time (very time consuming)?

Thanks -- DJ

 

[Tazguy37]

Put them in standalone modules, rather than ThisWorkbook modules, or in PERSONAL.XLS, or in an add-in,

 

[djl0525]

I like the standalone modules. That's a great idea. I didn't realize they aren't run when you open the workbook, but I looked at some of mine and, yea, that makes sense.

Thanks! -- DJ

 

[Joe Was]

Add a toggle switch to your code!

Public myTog As Boolean

Sub myCodeOnOff()

If myTog = True Then
myTog = False
Else
myTog = True
End If
Exit sub


myEventTypeSubCode, like:

If myTog <> True Then Exit Sub

'TheRestOfYourEventCodeHere!
Exit Sub

 

[djl0525]

I like this idea too, but I don't understand it. Like, where do I change the toggle? Can you add some documentation, please?

Thanks -- DJ

 

[Norie]

deleted

 

[Tazguy37]

I like this idea too, but I don't understand it. Like, where do I change the toggle? Can you add some documentation, please?

Thanks -- DJ

The myCodeOnOff() subroutine, when executed, will toggle the running of whatever code is here, as Joe wrote it:

'TheRestOfYourEventCodeHere!

Only if the myTog variable is True, will that code run.

 

[djl0525]

So I change "true" to "false" in this line when I want to turn it off?

myTog = True

DJ

 

[Joe Was]

No!

Do not change the True or False.

The toggle is just that a toggle!
A toggle is something that can be one of two things, like a light switch. If it is on the next time you press the switch it is off, if it is off the next time you press it it is on, over and over again!

The toggle code sets a variable that you can use to test for in an event code Sub.

If you want the event to run automatically flip the toggle by running its Sub or by Calling its Sub. If you want to stop running your code automatically the run the Toggle sub once again and your code will stop running automatically, Untill you run the toggle again!