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