Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Toolbar button to clear Filter

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I do a lot of filtering so I have the AutoFilter button on the toolbar. I click the AutoFilter button to filter a column. Clicking on the AutoFilter button again will not clear the filter and I have to use menu commands (Data Filter AutoFilter) to uncheck AutoFilter. Is there no toolbar button function to clear the Filter?

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Minnesota
    Posts
    821
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Copy this into a module to your personal.xls and then change the selection for your filter button to run this macro. It will turn the auto filter on or off

    Sub clear_auto_filter()
    '
    ' clear_auto_filter Macro

    '
    Selection.AutoFilter
    End Sub

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •