LordFordham
New Member
- Joined
- Mar 22, 2018
- Messages
- 1
Hi,
I've been attempting to lock/unlock a range of cells within a spreadsheet depending on the value selected in another cell. I have tried many different suggestions, and have made sure that the sheet is unprotected, but am coming a bit unstuck. Any help would be much appreciated.
The closest I have come to being able to achieve this was for the one row of the S/S, but this did not then replicate down all fields. Now frustratingly I can't even find the VBA code I'd entered to make that happen so unfortunately am starting from a blank!
The scenario that I have is that Column P contains a drop-down selection field with multiple options (which is applied to 1000 rows at the moment). I would like to lock down columns 'W:AD' on each row unless the option of either "Client" or "Fraud" is selected from the drop-down in cell P for that row. E.G. if Cell P5 is chosen "Client" then it would unlock W5:AD5. For any other selection from the drop-down list the chosen the fields W:AD would remain locked down (and ideally greyed out!).
Is there anyone who might be able to lend a hand and give me some direction on this please?
Many thanks in advance.
I've been attempting to lock/unlock a range of cells within a spreadsheet depending on the value selected in another cell. I have tried many different suggestions, and have made sure that the sheet is unprotected, but am coming a bit unstuck. Any help would be much appreciated.
The closest I have come to being able to achieve this was for the one row of the S/S, but this did not then replicate down all fields. Now frustratingly I can't even find the VBA code I'd entered to make that happen so unfortunately am starting from a blank!
The scenario that I have is that Column P contains a drop-down selection field with multiple options (which is applied to 1000 rows at the moment). I would like to lock down columns 'W:AD' on each row unless the option of either "Client" or "Fraud" is selected from the drop-down in cell P for that row. E.G. if Cell P5 is chosen "Client" then it would unlock W5:AD5. For any other selection from the drop-down list the chosen the fields W:AD would remain locked down (and ideally greyed out!).
Is there anyone who might be able to lend a hand and give me some direction on this please?
Many thanks in advance.
