Sharing Excel Spreadsheet with a password

AraliAlvarado Please see the attached workbook for a suggestion. The worksheet is currently protected with a password that only you should know to prevent any editing. Each student will open the sheet and enter their birthdate in the format of ddmmyy directly into the formula bar (that's the only place they could select because everything else is locked). Their Student ID will be populated if the password matches your record. 

Your records of Student ID and passwords are in column A and B (currently hidden).

You will unlock the sheet to unhide columns, make changes, etc. by the password "teacher".

Once you are done with your changes, go to Review/Protect Sheet/ enter your desired password, tick the box "protect contents ..." right below, ensure the only box of "Select unlocked cells" is ticked.