all above entered first

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.
 
G

GS

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.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top