Worksheet_SelectionChange event not triggered

[RedStarryGirl]

Hello,

I am not an experienced programmer, so I apologize if this is a simple question. I am using Excel 2007, and I have a macro (that is working) that I would like to run whenever there has been a new selection in a dropdown list on my worksheet. I have done this many times before in other workbooks, and I have always used:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

To my knowledge this should trigger the macro when the dropdown selection changes. However, this time it is not working. The macro runs fine manually, but it does not run when the dropdown selection changes. Any help would be greatly appreciated!

 

[RedStarryGirl]

Thanks for all of your suggestions. I ended up assigning a macro to the combo box. I put the code for my working macro into:

Sub DropDown1_Change()
End Sub

Now, the macro runs when the dropdown changes. Still not sure why it works in other files, but this will do for now. Thanks again!