Determine how a sub or function is called 1

[TRHorn]

Hello all,

I have a sub that is called upon selection change and I want to keep it that way. My problem is that when I run another sub it activates a sheet and highlights all the cells with formulas in them, so my first sub is called because the selection is changed, I do not want this to happen though.

Is there a way to tell my first sub not to run because it was called while my other sub is working?

Hope that was clear.

 

[PHV]

Have a look at the Application.EnableEvents property.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

Also, try NOT to code using Activate and Select methods. In most cases these methods are not necessary, and in fact, often counter-productive.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[TRHorn]

Perfect PHV, thank you.