A Real challenge....

do any of you Excel gods know how to set up a macro that would allow me to input specific users (students in this case) access to use a lab spreadsheet. Where would I input their specific student numbers to give them access?

I would like a prompt, for when a student goes to open a particular lab (one that they would be prompted to specify (eg lab #3), they would have to enter their student id. I believe this can only be done using a macro, however I am a newbie so please do forgive if there is any other way.

Also, after being granted permission, I would like them to only be able to enter data in specific cells once, and to enter values in sequence. If the data they enter is not within a specific range, I would like to have a prompt show up which would read something like "Value is Outside the Range, Please logout" and have the spreadsheet 'lock' so that they would not be able to input another answer. If the value they enter is within the range, they would input the next value until they either complete the inputs, or input an incorrect answer.

They would then logout and log back in to another lab, and their work would be saved in a specific folder of which only I could access (how would I set that up as well?)

Eg. Student opens up excel file
-they are prompted to enter their student number
-they are prompted to enter which lab # they wish to work on
-they are brought in to the spreadsheet which matches the lab they've requested.
-they would only be allowed to enter data in each lab once (so refusal of trying to login to a lab they have already worked on)

Is this at all possible, or am I way over my head.

Any help/suggestions would be greatly appreciated.

I have attached a sample spreadsheet in case anyone is brave enough, and clever enough to figure this out.

Thanks in advance,

MBS

it's good for me to know this is possible.

I just don't have the VBa skills to do this stuff (yet), though I am trying to work on it.

I wouldn't necessarily need extra security features to eliminate cheating, although I wouldn't frown upon it. That right now is secondary.

I'm amazed by the potential of programming.

Any other help would be appreciated.

MBS

I will need more details before I can give you any assistance in developing what you require.

How does the use of a form sound to you?

thanks again for your reply mudraker.

I've tried to find out more about forms and honestly would select any solution, as long as it worked the way I had originally intended (or even close at least).

So I guess a form could work. Not to sound like a newbie again or anything, but how would I use a form to my advantage?

I really appreciate you taking the time and giving your feedback.

MBS

Here is a very simple workbook with using forms

Depending on how complex the answer needs to be or the question then Inputbox might even work

again, I don't recognize nor understand "input box" nor how it works.

what you have suggested would work perfectly as it appears. I am going to try to figure this stuff out, if it kills me.

Your assistance is greatly appreciated.

MBS

A quick example of usin an inputbox - No forms to design or build

Please Login or Register  to view this content.