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