Macro for Split data into multiple sheets and to be hidden and password protected to unhide

[anchuri_chaitanya]

Hi,

A worksheet base on Column I 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.

Split_Worksheet_hidden_password to Unhide.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


Thanks & Regards
Chaitanya A
​

 

[anchuri_chaitanya]

Hi team,

Could anyone please help on this..