Forum Discussion
Microsoft Project VBA code to clear all applied filters
Please I need help with writing a VBA code (Macro) on Microsoft Project that will clear/remove all applied filters in a schedule. Thank you.
11 Replies
Hello
Another simple and immediate alternative is to include the "Clear filter" button in the Quick Access Bar. Pressing the button removes all active filters of any type.
Regards.
Ignacio
- Thanks Ignacio
- MeloNnadi,
Are you referring to auto-filtering applied on multiple fields in a view? Why not simply go to, View > data group > Filter selection box > [no filter]? You can record a macro of that process.
John- In addition, also in a situation that one applies a filter and forgets or you receive a schedule from a colleague and want to be sure that any applied filter is cleared, you can just run the same macro to clear any applied filter instead of taking time to search for which filter is applied. Thank you
John-project no John I'm not referring to just auto filter, that is easy to clear if you just have one filter by choosing no filter from the drop down. To clarify, i meant a situation where you have applied more than one filter (auto, custom and/or column). A macro that will enable you to clear all of them with one click of that macro (VBA code). I hope it is clearer now what i am looking for. Thank you so much.
- In addition, also in a situation that one applies a filter and forgets or you receive a schedule from a colleague and want to be sure that any applied filter is cleared, you can just run the same macro to clear any applied filter instead of taking time to search for which filter is applied. Thank you.
