Hello, please don't be mad, I have edited the file in order to hide sensitive data, and have used random place holder instead, but the file structure is the same.

The deal is on the top of the file there are 3 buttons (user1, user2 and user3). The code for those buttons us written under Module3 in VBA.
When a user is selected only the projects where he is the contact are shown. In the Column "N" there is Project Status e.g. CA or LI or RJ (those statuses can be changed at any time).
What i would like to achieve is that all projects that are with the status CP (complete), CA (cancelled) or RJ (rejected) are automatically filtered and not shown (hidden) when a user is selected , but still shown normally when "All" button is used.

Project.xlsm