Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Greetings,
I have created a button on a worksheet with the following code: Sub Macro4() ActiveSheet.ShowAllData End Sub When I have the Autofilter active for a column(s), I just press this button and the filter is taken off. No problems. However if I press the button when the Autofilter is not filtering any of the columns, I get a debug error. How do I tell the computer that if I press the button while the Autofilter is already off, don't do anything? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
auto filter question | Excel Worksheet Functions | |||
The Auto Filter button lost the column specified option. | Excel Worksheet Functions | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |