require cell to edit
You could use custom validation. Data - Validation - Custom
In the formula add something like the cell above < "" (for example
highlight cells A2:A10 and add validation =A1<"". Be sure to uncheck ignore
blanks.
This means that the cell above the current cell must be filled in before you
can fill in the current cell. First A1 then A2 then A3...
--
HTH...
Jim Thomlinson
"Sem" wrote:
Hello,
I'm actually working on Excel questionnaires. So I have lots of questions
that need to be filled in the correct order. I would like to lock or disable
every next cells until the previous answer is not filled. If possible without
using Macros or VBA
Thank you very much.
|