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

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.

Hi,

could anyone help on this, please..

A worksheet base on a column as criteria should be split into multiple worksheets

Which is the column?

Based on Column I, if you go thru the attached workbook, detailed in the worksheet "Rep & Manager"..

Hi Steven,

Tried the code you provided. Bingo! Its working beautiful.

Is it possible to provide the hidden sheets a password and as for "Master Sheet" entering the password clicking on submit button only to unhide a particular sheet of those.

For a particular REP/Manager of the sheets need to unhide only one sheet by entering the password and submit button.

This only the need. Other than this, your code is perfect, working exactly.

I am thankful to you.

Hi Steven,

Thanks for the code for Split, Hide and to Un hide the sheets.
I have tried to code for Password to un hide the sheets. It is done from my end.

Cheers..

The code I tried on a user form for Command Button..

Please Login or Register  to view this content.

In Master sheet I place hyperlinks for the Cell value and on clicking the cell it populates userform.

Please Login or Register  to view this content.

Hope this may help some one, if not please ignore.