all above entered first

  • Thread starter Thread starter cate
  • Start date Start date
C

cate

Is there a way to lock out cells without a lot of vba code; maybe with
none at all?

For example, insist column data entry is allowed only in order, with
no empty cells allowed. In a column, row 1 would have to contain data
before row 2 was unlocked.

Thank you.
 
cate submitted this idea :
Is there a way to lock out cells without a lot of vba code; maybe with
none at all?

For example, insist column data entry is allowed only in order, with
no empty cells allowed. In a column, row 1 would have to contain data
before row 2 was unlocked.

Thank you.
Click to expand...

Not without using a VBA event procedure. In this case your code can
insert the next row when required input is satisfied for the current
row. All unused rows are locked and sheet protection applied so users
can only access input fields.

<Non-VBA alternative>
You could use ConditionalFormatting to create the 'illusion' that row2
doesn't 'appear' until all required data is entered in row1. This would
require some hidden helper columns, but no VBA is needed. Effectively,
rows will continue to 'appear' as the current row data input completes.
In this scenario there is no sheet protection used.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
Back
Top