Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Friday, 14 September 2018
  0 Replies
  1.3K Visits
0
Votes
Undo
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
There are no replies made for this post yet.