Ive got lots of those 2 Code But different from Colom ad Row's
The Codes WORK as they Should BUT not when i make sheetprotection
Now a Description of what they Do.
Firstcode line:
cell L215 and L221 is activated by Enter 1 or 2 in cell when activated a VBA code set a Timestamp
Next to the Cell M215 and M221 and there is it the first code line take notice of wich cell i Entered a Value in First
=IF(M215< m221;b5;(if(m215>M221;B11)))
in cell M215 and M221 they are Activated by typing 1 or 2 in cell "L222 or L215"
Second Code line
is after first Code has Given 1 or 2 take notice of, if there is entere 1 or 2 in Cell L221 and L215
the function is to choose a Looser to take the chalkboard in next game
=IF(OG(D219=1;L221=1);D222;IF(OG(D219=1;L221=2);D221;IF(OG(D219=2;L215=1);D216;IF(OG(D219=2;L215=2);D215))))
The Codes WORK as they Should BUT not when i make sheetprotection
Now a Description of what they Do.
Firstcode line:
cell L215 and L221 is activated by Enter 1 or 2 in cell when activated a VBA code set a Timestamp
Next to the Cell M215 and M221 and there is it the first code line take notice of wich cell i Entered a Value in First
=IF(M215< m221;b5;(if(m215>M221;B11)))
in cell M215 and M221 they are Activated by typing 1 or 2 in cell "L222 or L215"
Second Code line
is after first Code has Given 1 or 2 take notice of, if there is entere 1 or 2 in Cell L221 and L215
the function is to choose a Looser to take the chalkboard in next game
=IF(OG(D219=1;L221=1);D222;IF(OG(D219=1;L221=2);D221;IF(OG(D219=2;L215=1);D216;IF(OG(D219=2;L215=2);D215))))
Last edited by a moderator:
