I have a VSB button that is toggling “Selection.AutoFilter” to turn on and off the filter option.
The on/off status is also toggling two other buttons but sometimes the file will open with the FILTER ON but my toggle is off.
Is there a Selection.AutoFilterON / Selection.AutoFilterOFF or something like that?
If your data table starts in cell A1 then this works as a toggle
Please Login or Register to view this content.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Hi,
Perhaps ActiveSheet.Autofiltermode if you merely need to know if there is an autofilter on the worksheet.
Don
Please remember to mark your thread 'Solved' when appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks