Allow cell editing for specific users

[Rocket123]

Hello,

I have a worksheet that needs approvals from certain individuals like CFO, DP's, etc.

I found a way to use Data Validation to only allow certain individuals to edit a cell based on the Approver (Windows User name) and Title.
On a hidden worksheet I have a table with two columns, Approvers & Title. For this example I only list 2 users.
Approver Title
Bob CFO
Fred DP

I have a macro that inserts the Window Users name in a cell.
If Bob opens the file on his computer, Bob's user name will do a lookup for his title. In this case Bob is the CFO and can only edit cell A1.
If Fred opens the file on his computer, Fred's user name will do a lookup for his title. In this case Fred is the DP and can only edit cell B1.
Data Validation formula for A1: AND(Approver=Window User, Title=CFO)
Data Validation formula for B1: AND(Approver=Window User, Title=DP)

I found with Data Validation, the CFO can input/delete data in A1 and cannot input data in B1 BUT he can delete data in B1.

How can I prevent Approvers from deleting data in other cells?

Is there a better way to do this?

Thank you for your help!!!