clear filter

  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. MishTaylor

    VBA Delete Entire Row in Table Based on Userform Selection

    Hi Everyone, I'm working on a project and am new to VBA. I've followed tons of tutorials online but I am stuck trying to delete a row in my table based on a selection made in a listbox within a user form. The purpose of the userform is to collect data on reallocating medication that was taken...
    • MishTaylor
    • Thread
    • clear a range clear filter delete a row delete button user selection userform vba vbacode
    • Replies: 5
    • Forum: Excel Questions
  3. M

    How to use a loop to clear all filters in all tables in a workbook?

    Windows 7, Excel 2010 I have workbook with 6 data tables fed by data connections. When I close the workbook, I want to clear all the filters in each of the tables before saving and closing the workbook. I have a lazy macro that loops through the each table and sheet, but doesn't clear the...

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