clear filters

  1. Chris_010101

    Clear filters from ALL sheets, on workbook close

    Hi I need a VBA code to clear/reset all filters from all sheets upon workbook close. A number of users of a workbook are always leaving filtered criteria applied and exiting. With some sheets having 100 columns, it sometimes causes problems when others open the workbook and think data is...
    • Chris_010101
    • Thread
    • clear clear filter clear filters excel filtered criteria help macro vba visual basic
    • Replies: 3
    • Forum: Excel Questions
  2. J

    Unable to filter and cels copy information from other tabs

    Hi all I have a bit of a wierd problem I have saved a spreadsheet on our server as a shared workbook that gets populated from a userform on my(or the other users desktop) The macro opens the workbook on the server, copys in the info from the userform into the "Master Data File", saves the...
  3. V

    VBA to disable clear all filters

    Guys, I have protected workbook but I've allowed using pivot tables in it. Users of this excel file can sort data with slicers. I want disable users to clear all filters when activate clear button from data tab. I've tried this: Application.CommandBars("Edit").Controls("Clear"). Enabled =...
  4. M

    How do I clear filters in Worksheets and Tables?

    Using Excel 2010 on Windows 7, I have a workbook with many sheets, some of which contain more than 1 data data table that is fed by data connections. I have the following code. When the code runs, if the cursor is within a table, the table's filters are cleared. But if the active cell is not...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top