Workbook alternating between showing autofilter and then not showing it each time workbook is opened... how to always show it?

[kbishop94]

I save the workbook, then close it.
Open it up, and autofilter is showing:


then, save & close it again...
and then open it back up,

and now its no longer showing...(?):

So I save it once more, and then the next time I open it, it will be back to showing once again(!) (and again, save it one more time and of course next time I open it it goes back to not showing....) whats causing this crazy loop?

Private Sub Workbook_Open()
'
    If ActiveSheet.AutoFilterMode Then
        ActiveSheet.Range("C2:S2").AutoFilter
    Else
        ActiveSheet.Range("C2:S2").AutoFilter
    End If
'

I've tried putting the above code in different places (at the very top of the workbook open event and also at the very bottom) as well as trying different variations of the code, but it still behaves exactly the same; it will show once, then next time, it wont. wtheck?
Thanks

 

[SanjayGMusafir]

whats causing this crazy loop?

If Autofilter is on and you ask it to autofilter, the filter arrows will go off and vica versa

That is why they keep alternating...

You can try that by using keyboard shortcut Ctrl+Shift+F (in mac) there must be similar or same in windows, to understand the scenario

 

[Fluff]

How about

    If ActiveSheet.AutoFilterMode Then
    Else
        ActiveSheet.Range("C2:S2").AutoFilter
    End If

 

[kbishop94]

How about

    If ActiveSheet.AutoFilterMode Then
    Else
        ActiveSheet.Range("C2:S2").AutoFilter
    End If

Weird. that did the trick.. (for whatever reason! lol)

 

[Fluff]

If the autofilter is on then you were turning it off.

 

[kbishop94]

If Autofilter is on and you ask it to autofilter, the filter arrows will go off and vica versa

That is why they keep alternating...

You can try that by using keyboard shortcut Ctrl+Shift+F (in mac) there must be similar or same in windows, to understand the scenario

yes, i understand that (believe it or not lol) But the code is supposed to (so I thought.. and it does work in another workbook... ) keep it on regardless if its showing one time or not showing... Oh well. Its working now! Thank you for the reply.

 

[Fluff]

You're welcome & thanks for the feedback.