Removing filters when closing sheet

**stait** · 06-29-2010, 11:01 AM

I have a sheet which is used by many people. I am finding that people are using the filters but not turning off the firlters when the save and close. This is causing issues for other users as they then need to try to figure out what filters are on. Is there a macro which will trun off all filters when you close the sheet/workbook?

Thank you

Stephen

**royUK** · 06-29-2010, 11:07 AM

Something like

Please Login or Register  to view this content.

But they will have to have macros enabled

**stait** · 06-29-2010, 02:30 PM

Thank you. I added this into a madule, but it does not work. Is there a special way I need to add this? Is there another command I need to add?

**royUK** · 06-29-2010, 03:29 PM

This is Workbook Event code, it should be added to the workbook code module:

Copy the Excel VBA code
Select the workbook in which you want to store the code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
In the Project Explorer, find your workbook, and open the list of Microsoft Excel Objects
Right-click on the ThisWorkbook object, and choose View Code
Where the cursor is flashing, choose Edit | Paste

**stait** · 07-02-2010, 10:00 AM

Originally Posted by royUK

This is Workbook Event code, it should be added to the workbook code module:

Copy the Excel VBA code
Select the workbook in which you want to store the code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
In the Project Explorer, find your workbook, and open the list of Microsoft Excel Objects
Right-click on the ThisWorkbook object, and choose View Code
Where the cursor is flashing, choose Edit | Paste

I still cannot seem to get this to work when I close the sheet. I will find another way.

Thank you for your help.

Stephen