Hi,
I'm far from being the best in VBA code and I'm trying to create a code that I know is not that hard to do but I'm stuck everywhere. Let me explain
I have 27 column (A : AA)
I have X numbers of row (not important)
What I want :
STEP 1 : If I enter "test" or if the cell is red in "AA" it lock all the row
STEP 2 : if I click anywhere in this row it ask for a password and if the password is goos it ulock the row rand remove the red
*note* even if for exemple the row 12 is locked I still can edit anything in other row
thanks in advance if anyone can help me
I tried a lot of code and the nearest one I found and tried are these ones :