Rob_010101
Board Regular
- Joined
- Jul 24, 2017
- Messages
- 198
- Office Version
- 365
- Platform
- Windows
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 missing. There are about 40 people who use this workbook and some are not advanced excel users.
The code should not get rid of the filters, just clear the filtered criteria when the workbook is closed so that it's reset back to showing all data when anyone opens it.
KR
Chris
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 missing. There are about 40 people who use this workbook and some are not advanced excel users.
The code should not get rid of the filters, just clear the filtered criteria when the workbook is closed so that it's reset back to showing all data when anyone opens it.
KR
Chris