Popup Warning Box

[Acoustic]

Hi All,
I'm hoping this is possible, I have created a macro button on a page to filter another sheet but find if someone manually filters that sheet then clicks the macro button it returns nothing on the filetered sheet. This is obvious to me why, as it is filtered already but wish to flag some sort of warning when it returns a blank page.

is this possible

cheers guys

 

[shadow12345]

no reason why not... but you could have your code check for a filter and then either not run or remove the filter instead....


Could you post your code?


* This would remove the filter already there (even if its not there) then you could just run your filter.
With ActiveSheet

.AutoFilterMode = False

 

[Michael M]

Maybe incorporate this in your code, without the Sub and End Sub

Sub msg()
MsgBox "The sheet is already filtered, " & _
        "please unfilter and try again.", vbOKOnly
End Sub

Otherwise post your code and we'll put it in for you.....but best if you try it first !!

 

[Acoustic]

Cheers guys, i actually didnt code this, i used a recorded button macro. I do have the option to record the button macro with a "show all" incorporated in it, but this seems very timely on these very slow machines they give us.