| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB to clear any filters when closing a spreadsheet
Hi
I want to enter some vb to a Workbook_BeforeClose option that automatically clears any filters in a specific sheet as the workbook is closed. Example of recorded code is below which works but I have the sheet protected so I do not believe below code is optimal for a protected sheet. Is there simple code to simply clear any filters? Range("A1").Select Selection.AutoFilter Selection.AutoFilter -- Kevin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to clear all filters in worksheet for all columns | Excel Discussion (Misc queries) | |||
| How can I clear all cells containing #n/a on a spreadsheet? | Excel Worksheet Functions | |||
| Closing Excel spreadsheet | Excel Discussion (Misc queries) | |||
| CLEAR FIND BUFFER UPON CLOSING | Excel Worksheet Functions | |||
| Dialog box when closing an unsaved spreadsheet | Excel Discussion (Misc queries) | |||
Threaded Mode
