L
Legacy 287389
Guest
Hi good people!,
I have posted a similar thread but this one incorporates a change and I believe this approach will be easier. Please please help, I have honestly searched the forums up to the point of loosing my mind...
Cells A1 and A2. If the contents of cell A1 changes (by means of formula) to "na()", A2 must lock, otherwise A2 must un-lock. The range affected is A1:G20. In this range when all or any Odd number rows change values to "na()", the cell just below in the even numbered row, must lock.
The sheet is protected. So, the sheet should un-protect and then again protect, But without the need for a password prompt. Only in the event of someone trying to manually un-protect the sheet, should a password be prompted. Will anyone please assist me?...I will be eternally grateful...
I have posted a similar thread but this one incorporates a change and I believe this approach will be easier. Please please help, I have honestly searched the forums up to the point of loosing my mind...
Cells A1 and A2. If the contents of cell A1 changes (by means of formula) to "na()", A2 must lock, otherwise A2 must un-lock. The range affected is A1:G20. In this range when all or any Odd number rows change values to "na()", the cell just below in the even numbered row, must lock.
The sheet is protected. So, the sheet should un-protect and then again protect, But without the need for a password prompt. Only in the event of someone trying to manually un-protect the sheet, should a password be prompted. Will anyone please assist me?...I will be eternally grateful...