password protect each sheet

[Andrew1995]

hi there
i have created a workbook with many sheets. each sheet is a grade sheet for students which they have a unique id and password written in it.i want when i run the macros to create a copy of the workbook and when i open the copied workbook to directly show a search box for the students to add their unique id and password to show only their corresponding grade sheet. i want all other options,information and editing to be disabled . Thanks a lot any help appreciated. i am new at this please help.

 

[Fluff]

Duplicate School Project

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).