I have a button on a worksheet to 'Show All Records'.

There are two ways i found to do it, ie:

ActiveSheet.ShowAllData

and

If ActiveSheet.AutoFilterMode Then
ActiveSheet.AutoFilterMode = False
End If

How do I display a message box saying "All records shown" if the use
clicks the button when the records are not filtered?

I found that the second way erases the filter arrows. I would like th
filter arrows at the top to remain.

Would appreciate anyones help, thanks

--
Message posted from http://www.ExcelForum.com