Hi, I'm a VBA novice and been able to add a button on the ribbon which I intend to use on whatever sheet is active to "unhide/unfilter/showall/showeverything". I've searched for the code in a bunch of places and found various snippets that were thought to work, but I've been unable to get working... Sub Macro3(control As IRibbonControl) ActiveSheet.AutoFilter = False ' I also tried ActiveSheet.AutoFilterMode = False --no luck. End Sub I realize this small snippet wont unhide/or do everything, but I figured I would at least try to reset filters and build on it from there. Any ideas? Thanks, BT

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Unsort/Unfilter/Unhide Everything!

Thread starter btdown
Start date May 31, 2012

btdown

New Member

May 31, 2012

Hi,
I'm a VBA novice and been able to add a button on the ribbon which I intend to use on whatever sheet is active to "unhide/unfilter/showall/showeverything". I've searched for the code in a bunch of places and found various snippets that were thought to work, but I've been unable to get working...

Code:

Sub Macro3(control As IRibbonControl)
ActiveSheet.AutoFilter = False
' I also tried ActiveSheet.AutoFilterMode = False --no luck.
End Sub

I realize this small snippet wont unhide/or do everything, but I figured I would at least try to reset filters and build on it from there.

Any ideas?
Thanks,
BT