ExcelBanter - Select cells below and lock them

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Select cells below and lock them (https://www.excelbanter.com/excel-discussion-misc-queries/102627-select-cells-below-lock-them.html)

chrisk

Select cells below and lock them

i want to put "COR" in A1 and have B1 C1 & D1 unavailable for use.(ie the 3
below blocked)
or i want to put "B" in A1 and have B1 unavailable for use.(ie the 1 below
blocked)

All times are GMT +1. The time now is 06:39 AM.