I am hoping that someone can answer a specific question.

Is there a way to create a spreadsheet (without using macros/vbasic) that would only allow another user to input data in specific cells in a specific order, then if there data does not meet a pre-determined condition, stop the user from being able to move on? At the same time the user would only be able to input his/her data once.

Re: I am trying to set up a spreadsheet for students to input data into certain fields. I would like to be able to set the spreadsheet up in this regard;

i) First of all, they would only be able to access the spreadsheet once (is this possible?)

ii) Secondly, once in the spreadsheet, they would input data into specific un-locked cells in a precise sequence (ie. #1, #2, #3...)

iii) If their value does not meet the pre-determined amount within a certain percentage of error, Is it possible to terminate their use of the spreadsheet, and still gain access to their work (to be graded)

If not possible without macros/VB, would it be very difficult to set something up like this just by reading up on VB and the language.


Any help would be greatly appreciated.

-M.B.S