Hello

I need some help with this please. I want to create a Marco that will run if
the condition met.


A B
1 yes 100
2 yes 656
3 yes 556
4 yes 964
5 no 632
6 yes 496
7 no 656464
8 no 656
9 yes 656

For example
If A1 equal to €œYes€� then Cell B1 will be unprotected and if its equal to
€œNo€� then the cell will remain protected. So after the Marco, the Cell
B1,B2,B3,B4,B6,B9 will be unprotected.

Do I need to create a Marco button for this or would it be possible just for
the Marco to run when Cell A1 equal to Yes.

Thank you very much!!!

Harn