Hi,


I have never run a VBA before so i would need advice on how and where i protect the cells before entering the VBA.

I am looking to lock a cell based on data in another cell.

If D6 = £0.00 i want B7 to be unlocked
If D6 = anything other than zero then i want B7 to be locked

Is this possible?

Thanks,
Nat