H
Harn88
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 it’s 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
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 it’s 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