Hi Team,

A worksheet base on a column as criteria should be split into multiple worksheets and those sheets should be hidden and to assign a password to unhide.
A worksheet called "Master" which has a text box entering a password and clicking on the submit button then that particular sheet should be unhidden.

Please find the attached workbook which will be clear to understand.

Book1.xlsx

Every day process of doing this kind of activity, thought of being helped by the team to get out of the work risk.

Hope, I am in right way. Anyone's help will be appreciable and that would be a great help for me.