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!