macro not running on separate sheets within same workbook

[KHum]

Hi- was able to get

>>> use code - tags <<<

Private Sub Worksheet_Change(ByVal Target As Range)

    ActiveSheet.AutoFilter.ApplyFilter

End Sub

to run on the first sheet but not the second. When I try to run the macro it keeps popping up this box- I've attached an image of the screen.

How do I make this work? I honestly only got it to work on the first sheet by accident and I'm not sure what I did.

 

[vletm]

KHum
Do You have that code in every sheet's code-page?

 

[KHum]

KHum
Do You have that code in every sheet's code-page?

yes- or at least I think I do

 

[vletm]

KHum
... which one?
If yes then send a sample Excel-file here.

 

[KHum]

this is my best approximation of a sample

 

[vletm]

KHum
As I tried to ask: Do You have that code in every sheet's code-page?
Your wrote: yes- or at least I think I do
Did You check it like below?


or did You see as below?

 

[KHum]

it looks like the second option
and it still isn't working.

 

[KHum]

I made sure both windows looked like you showed me and closed out of excel entirely- not closing the file and now it works. Thank you very much for your patience!