Running Macro on worksheet change

[OldManDemosthenes]

I feel like this should be an easy one but then here I am....

I am trying to run a macro when something on a worksheet changes

I've tried both of the following codes with no luck:

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
[INDENT]If Not Intersect(Target, Worksheets("Inputs").Range("A1:H114")) Is Nothing Then[/INDENT]
[INDENT][INDENT]Call Macro1[/INDENT][/INDENT]
[INDENT]End If[/INDENT]
Application.EnableEvents = True
End Sub

and

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
[INDENT][INDENT]Call Macro1[/INDENT][/INDENT]
Application.EnableEvents = True
End Sub

Thanks

 

[RSXchin]

Just to be clear, that code is in the Worksheet Object module, right?

 

[p45cal]

1. The code is in the code module of the sheet concerned? (You shouldn't have to qualify with Worksheets("Inputs") if it is.)
2. Type
?Application.enableevents
in the Immediate pane - you're looking for True, if it's false, then type:
Application.EnableEvents=True
and Return to make it true. Then try again.
3. Put a Break, or a Stop command at the beginning of the event handler code so that you go into debug mode when it reaches that line. If it doesn't happen, you're not triggering the event.

 

[OldManDemosthenes]

I didn't follow you entirely but yes the code was written in the proper worksheet code.

I just re-entered my first code and everything worked. Don't know what happened, but I'm not complaining

Thanks for responding p45cal

 

[OldManDemosthenes]

And now it stopped working... I didn't change anything ???

 

[RSXchin]

It will only work on the sheet that you have the code in. If you want it to work on EVERY worksheet. Put it in the ThisWorkbook part. change the "Worksheet_Change" part into "Worksheet_SheetChange"

 

[OldManDemosthenes]

I've only been working with the sheet with the code, although I will eventually branch out to other sheets as well. I think I'm probably missing the obvious. I'll tinker with it some more and post back if I can't get it.

Thanks for assisting

 

[RSXchin]

what part isn't working? is the event not being recognized, is the macro not doing what it should? MAYBE your macro has a line that enables events? You don't want that.

 

[OldManDemosthenes]

The macro works fine. I can run it independently without any problems.

What happens is sometimes I will change something on the sheet within the designated range (from the worksheet change code) and the macro will run as planned. Most of the time nothing happens though....

Sorry if I'm coming off a bit frustrated - its been a long day at the end of a very busy week and this model has me a bit fried.

 

[RSXchin]

Please post all 3 codes exactly as you have them.