Cannot run macro may not be in this workbook? - I've changed by Module names?

[Melimob]

Hi

I am trying to run this macro to run upon a drop down list change and am getting an error that the macro might not be in this workbook?

I've noticed that all the macros I renamed now show with the workbookname then macro? please what have I done wrong and how to I fix?

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 7 And Target.Column = 3 Then
Application.Run "Filtering_Country"
End If
End Sub

many thnks

 

[Melimob]

Below is SOLVED - turns out you shouldn't name the module the same as your macro which is what I had done! lesson learned

Hi

I am trying to run this macro to run upon a drop down list change and am getting an error that the macro might not be in this workbook?

I've noticed that all the macros I renamed now show with the workbookname then macro? please what have I done wrong and how to I fix?

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 7 And Target.Column = 3 Then
Application.Run "Filtering_Country"
End If
End Sub

many thnks