How to hide certain sheets with password

**marcielo** · 11-17-2011, 10:45 AM

Hello

I´m trying to achieve the possibility to hide some sheets with a password, but not all.

I found this thread:
http://www.excelforum.com/excel-prog...-password.html

Where all the sheets are hidden with a password, but since I'm not a coder, I´m not able to get some of the sheets to be hidden and some visible by default.

The workbook has this:

Please Login or Register  to view this content.

and the module:

Please Login or Register  to view this content.

Hope someone can help me.

**111StepsAhead** · 11-17-2011, 11:26 AM

I would go about it by having a worksheet called "usernames" that is always xlSheetVeryHidden.

Please Login or Register  to view this content.

And then in column A store the usernames and in column B store the passwords. (Username can be the name of the worksheet you are hiding.)

So have a userform popup with 2 different entries. 1 for the username and 1 for the password.

Search the hidden worksheet by looping through each value in column A. (http://www.mrexcel.com/td0058.html)

Please Login or Register  to view this content.

See what you can do with the above. It is pseudocode so it won't work but should help you get started.

Tutorial:

Please Login or Register  to view this content.

Option explicit means you have to define all your variables as a data type.
So "Dim someVariable As String"
means you made a variable called someVariable and it will hold data of the type "String".

The next line means for each worksheet in the workbook you will check the sheets. If the first worksheet is not the first sheet then you hide it. Repeat and check all the worksheets.

The final line saves it.

If you want to select which sheets are hidden or not hidden you need to change that code.

Please Login or Register  to view this content.

Hope this gives you a good start.

**royUK** · 11-18-2011, 03:39 AM

Have a look at the password form

**marcielo** · 11-22-2011, 08:30 AM

Thank you for the replies

111StepsAhead: Without your help I would not have achieved - thanks a lot!!

royUK: Thank you for the file, but unfortunately I was not able to access the code, cause it wants me to enter a password no matter what I do.

Thank you again for taking the time!!!

**john55** · 11-22-2011, 08:54 AM

hi marcielo,
as an option
open the Roy's file with "Manager" and password "secret", or click on the tab name, view code and set to visible the Sheet1!

**joenathaniel26** · 03-27-2013, 04:53 PM

Hi Roy, thank you for the file, but when I tried it like in 3 instances the user have entered the wrong password, it says the workbook will now close, but it doenst really close, and to add, every time I close the worksheet, the sheet "hide this sheet" always becomes visible even I tried to put it, sheetveryhidden. thank you.