Worksheet_Change Not Being Triggered

[Claymation]

I have the following piece of code on my "Summary" sheet in my workbook. Basically if D7 = Total, then it is supposed to run another macro called OrderTypeFilter. If D8 = Total then it should run RxTypeFilter (D7 & D8 are validation dropdowns). Both of the other macros run fine separately, but for some reason if I select Total in the dropdowns in D7 & D8 nothing happens.

Can anyone see why they are not being triggered correctly? I can't seem to figure it out.

Please Login or Register  to view this content.

Similar question also posted on - http://www.mrexcel.com/forum/showthr...=1#post2490599

Any help is appreciated.

[Claymation]

I think that I may have figured it out...I believe that somehow the events were turned off.

To turn them back on:

1 Goto the immediate window (CTRL+G)

2 Type Application.EnableEvents = True and hit Enter.

[TMS]

'If Target.Value = "Total"' is case sensitive. Are you inputting Total with a capital "T"?

Regards

[TMS]

I wondered about that.

You disable/enable event handling in the Change event macro but then go off to other procedures. Could it not make its way back and re-enable the event handling?

I try to limit the management of events to the immediate vicinity where it needs to be controlled to (try to) avoid this situation.

Regards

[Domski]

I assume the code is located on the worksheet's code page rather than in a module?

I tested it and it seems to work fine for me.

Dom

[Domski]

I think that I may have figured it out...I believe that somehow the events were turned off.

Aye, that would make a big difference

You need to find out what turned it off and make sure it doesn't happen again by mistake.

Dom

[TMS]

The other issue is that, if you are stepping through code to check/test it, it's easy not to step through to the end. Hence the problem.

Regards

[Claymation]

Aye, that would make a big difference

You need to find out what turned it off and make sure it doesn't happen again by mistake.

Dom

I think that I am still having some issues with this. I am not sure exactly where it is being turned on/off, but have to go through and manually change it occasionally. Is that portion of the code necessary, or can I just remove it so that I don't end up accidentally changing it?

[Claymation]

Just so that I can be more specific with what I am working with, here is the code that I am using.

This is the Worksheet_Change on the "Summary" tab:

Please Login or Register  to view this content.

Then I have these pieces of code in Module1:

Please Login or Register  to view this content.

Any help is appreciated. Thanks.

[romperstomper]

If you turn off events, you should always have an error handler so that they get turned back on, no matter what else happens.

[Claymation]

If you turn off events, you should always have an error handler so that they get turned back on, no matter what else happens.

I am not sure exactly how I would add that into the code that I have listed above...any help is appreciated.

[romperstomper]

For example:

Please Login or Register  to view this content.