Worksheet_change will not run automatically

[Aydrian13]

I cannot get either worksheet_change or worksheet_calculate to fire upon a change in a worksheet. I haven't found the answer on any forum. I created a dummy file to fire a goal seek automatically (also tried firing a simple msgbox, which didn't work either).

My settings are:

- Enable all macros
- Trust access to the VBA project object model

I inserted the code with a right click on the worksheet I was in, so I think it's in the right place. Also, my goal seek runs correctly if I click F5 in the code. I just can't get this to run on a worksheet change.

I'm new to VBA, though I'm pretty sophisticated with Excel otherwise. Any help would be greatly appreciated. My code is as follows:

Private Sub Worksheet_Change()
TEST
End Sub

Sub TEST()
Range("C4").GoalSeek Goal:=Range("e4"), ChangingCell:=Range("C6")
End Sub