Forum Discussion
MeloNnadi
Mar 08, 2024Copper Contributor
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.
John-project
Mar 08, 2024Silver Contributor
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
MeloNnadi
Mar 08, 2024Copper Contributor
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