Locking cells

[NatNat]

How would I go about getting excel to lock a set of cells unless the previous ones are completed, perhaps indicating that you can proceed by a tick beside the previous cell

[JBeaucaire]

You can use a Worksheet_SelectionChange event in the in the VBA Sheet Module which watches the cell selections. Constructed properly, it could force the cursor BACK across a row to the cell requiring input before allowing access to then next empty cell.

For instance, let's say the process goes like this:

A1 then B1 then C1 then D1.

Column A can be accessed anytime, but when your cursor tries to enter column B, the macro checks column A for any value... If one is found, column B access is allowed, if not...the cursor is pushed back to column A. This same behavior is repeated for C and D.

Is this the sort of thing you had in mind?

If so, describe fully the sequence of cells that require data in them to proceed to the next and I can help you construct a Worksheet_SelectionChange event macro.

Using this would require you to have macros enabled on your sheet, hope that's ok.