1

My professor want me to send out an excel sheet which contains grades of all students. And of course every student can only see his own grade. So he want me to set passwords for the grade cells. Each student will have his own password, and when he click his grade cell the sheet will ask for a password. If he entered correctly, then he will be able to see the grades.

How can I implement this? I tried using "hide" and ";;;" format for sells. And set password protection for the cell. using "allow user edit range" but when user enter the range password everything in the cell just go away.

Is there anyway to do this using a VBA? I tried some codes but does not work.

Thanks!

5
  • pretty sure this is not possible. Source Hiding the cell and revealing it as they click the cell doesn't seem to exist as a function. Feb 19, 2014 at 19:58
  • I feel like it would be more secure to have an Excel function/VBA script that loops through the list, creating a new worksheet for each student and emailing only their result(s). Feb 19, 2014 at 20:15
  • Yes, this is possible via VBA. It'd be much easier in pretty much any other medium, this is a huge request. Not to mention you'd have to lock the VBA code otherwise students would be able to view the passwords for others.. Feb 19, 2014 at 20:29
  • This page is probably going to give you most of the tools you need to get something working: msdn.microsoft.com/en-us/library/office/… Feb 19, 2014 at 21:01
  • It would probably be easier to extract the grades and send them to each student individually.
    – David
    Feb 19, 2014 at 21:10

1 Answer 1

0

I agree with the other comments that having a master workbook that emails individual sheets to students would be a sensible approach, Excel isn't designed to be that secure.

Having said that, if really pressed and if I had control over the passwords, I'd keep the data in hidden sheets one-way encrypted. So you have to know the password to see the data.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .