Hide Selected Sheets And No Unhide Without Entering Password

[HaroonSid]

Hello Evryone

i want to hide selected sheets and when i want to unhide them, ask for password to unhide the sheets

plz help
haroon2015

[ragulduy]

Put something like:

Please Login or Register  to view this content.

in the sheet object module

or use xlsheetveryhidden to make the sheets only unhideable by code and make your own routine/button.

[HaroonSid]

thanx for reply

but if i have sheet1, sheet2, sheet3, sheet4, sheet5, sheet6, sheet7, sheet8

and

i want only hide sheet1, and sheet7

then ?

[ragulduy]

In the code "Me" refers to the sheet object in which the code is stored, so if you put it in only the sheet1 and sheet7 modules it will only affect those sheets. Have a look at the attachment for an example.

[HaroonSid]

working very well but

step 1st = if when i type password it looks should be like (********)

[ragulduy]

Hi, that is more complicated. You have two options:
-Create your own userform instead of an inputbox and set the passwordchar property to *
-Use the code in the link below (post #3) to create an inputbox with passwordchar "*" using API:
http://www.mrexcel.com/forum/excel-q...asterisks.html

[HaroonSid]

ragulduy

PLZ HELP WITH THIS ONE

Create your own userform instead of an inputbox and set the passwordchar property to *

[ragulduy]

What do you need help with?

[HaroonSid]

Using userform to protect password multiple sheets

[ragulduy]

I would suggest you need to make a new thread on how to create a userform, or trying reading a book or looking on google. There are many walkthroughs available for this. Here is a link to get you started:
https://www.google.co.uk/search?q=vb...54.SRk0-vVrD_o

[HaroonSid]

ok thanx a lot