Hide/UnHide Multiple Sheets with different passwords for each Sheet except the Main Sheet.

Dear Forum,

I need to Hide Multiple Sheets in a Workbook as this common file would be sent to every Location and I want to provide different recipients different password to open each sheet.

I would like to create a list of passwords and then all the Sheets except the Sheet where the passwords are stored get closed and would only open when the user enters the correct password.

When the user tries to open the sheet it should provide an Input Box to capture the password...

I need to have different passwords for each different sheet as each sheet would be named as per the Region.

Ex: MainSheet\Mumbai\Delhi\Bangalore

Lets say my Password for Mumbai - "Mum2018457", Delhi- "Del2018754" and Bangalore- "Ban2018574"

So I have a Range of Sheet Names in the Col A and the passwords in Col B
Col A----------Col B
SheetNames--Passwords
Mumbai------ "Mum2018457"
Delhi--------- "Del2018754"
Bangalore--- "Ban2018574"

Found a few codes but unable to use them..

Regards
e4excel

one last thing, there is a hidden sheet (called hdn_Codes) that can show the sheet with the user Master and password is Password. that way you can manage your passwords on the sheet.

Thanks dmcgov....You have done a wonderful job, however it gets UnHidden with normal way as well....
So please do that small bit of coding to prevent it from getting UnHidden it should not be actually shown in the list to unHide

Dear Dabho,
Thanks for your help but I am getting an error in the line If .exists...

ok i fixed the hidden sheet issue. below is the workbook. note that the VBA password is "password", you will want to protect the code so that someone can't write code to show the sheets.

i am working on a password hashing macro so that the passwords are not exposed in cleartext.

let me know if you need anything else.

Thanks once again but can you please put the Focus back on the Successful Password Sheet..Example if I out the correct password thee Focus should go in the Cell A1 of Mumbai..Please do work on that hashcode..and I would have more than 32 Sheets so is there a way I can write a loop..

Please can you please explain your code so that I can tweak it a bit.. Thanks once again

i never removed the setfocus, it still is in the button code for the userform. it should ask you for a city, then type in master, this should open the password textbox and the focus should be on the textbox so that all you have to do is type and it should show up.

so you have more than 32 sheets, do you have a list of the cities in a range perhaps?

all of module 1 is for showing the userform and resetting the textstring to ""
for the userforms, the first button if for the OK which passes the password, the second is cancel which just a way of closing the form
the code for mainsheet is where you would add cities
and ThisWorkbook is where you veryhide the sheets.

so for you adding code, just add all your cities (since you have more that 26 cities, you wont be able to use character1 for the code, so use two or three shortcodes for the cities (like MUMbai or BAngledesh) that should get you going. if you need moreof my help, just upload what you have and i will work with that.

note still working on the hashcode, its tricky.

got the hashcode working but i have some questions for you. are you still planning on using this solution?

óf course I am preety impressed with your helping nature and your code..
I was mentioning the Set Focus on password successful entry. I need to go that Sheet which gets Unhidden..
I have a list of 32 Sheets with any password which you choose..

please upload a list of cities (any format is good). i will use that to create a loop of the cities.

Thanks... but you can make an example of any four cities in a loop..i will tweak as im at home do not h ave the list now

well, i can see where this would be cumbersome with 32 cities. so on MainSheet, i have a button to unhide the cities by password. below is the line.

Please Login or Register  to view this content.

if i create a loop instead of an inputbox, then your users will have to cycle though each city to find the one that is theirs which could mean answering No 31 times (if their city was last) so i think its better to have the inputbox. rather than list 32 cities, i can simply change the inputbox to

Please Login or Register  to view this content.

so that they type in the city to the inputbox. the other way (more cumbersome) is to create a userform (but again with 32 cities, that would crowd the form. not sure i would want to do that.

I think that a Single Input Box to any city would be great

ok, i can do that easy peasy. when you get to work (or wherever), send me a list of the cities so that i can code them for the inputbox.

here is a sample of what that would look like.

Please Login or Register  to view this content.

so i would code an ElseIf for each city. no loop.

so i have the password portion of the macro working. so this is good to go (For testing purposes), note that i still need a list of your cities to finish the project.