Mask password entry

[Throughstream]

Hi I have this simple password entry code that works great but when entered the password can be seen. I'm looking for a way of masking the password so that it can't be seen when entered.

Please Login or Register  to view this content.

Cheers

Dave

[Keebellah]

Hi Dave, if you want to use an Inpoutbox then you'll have to resort to another method.
I found and used this for a long time, Found it somewhere inMarch 2003 the links and references are in the module.
It uses a modified InputBox

I now use a Userform instead where you can mask or show what you enter. But that's another story


Let me know if you need help to getting it to work, I think it's clear enough, I had no problems in 2003

[Keebellah]

I just read your previous thread and you can use the module for that too, if you don't want people to know what the password is that you have in vba modules you will have to lock the project from view and password protect it
This is always breakable but for the normal user it's not accessible

My preference would be to go for the userform as was said in your previous post.

[Throughstream]

Hi many thanks, I've attached the module in. However how do I make the vba work in same way as my current code so that when a specific sheet tab is selected it asks for the password without showing the data on that page and if entered incorrectly takes you back to a specific sheet. If it's easier I don't mind using user form instead.


Many thanks

[Throughstream]

Hi sorry think we posted at the same time. I’m happy to go with a userform, but have no experience in creating one unfortunately.

[Keebellah]

You mention the module, is that the portion of code you posted?
I don't really see what it does, Range 60000 is that to take you off the screen?
What is the idea?
You want to trigger a password request for when a worksheet tab is selected but do not want to show it before the password is verified. Is that correct?

Does this happen with every sheet or is there one starting sheet that you want the user to be sent to if the password is incorrect?

A little more information about the strategy YOU envision, I don't build on assumptions since my track of mind is never the same as the one posting. I like to think with you but not jump into it without a basic idea.

[Throughstream]

Hi so the idea is that when a user loads up the document it takes them to sheet(26) what i want to do is then bloack them from viewing any other sheet unless they know the password. If they know the password then I want them to have access to all the other sheets. The idea behind sending it to range 600000 was that there was no information at that range and therefor they couldn’t see anything. Thank you

[Keebellah]

Message crossed, but this is a sample file with fake data to show thee idea with the code I posted previously.
The password is PASSWORD
It has four sheets

Select a Tab and ... have fun

[Throughstream]

Many many thanks that's prefect

The only thing I've noticed is that I get this message when I change the password

Capture.JPG

[Keebellah]

That had ontging Yo do with password change,check under excel options the settings for personal settings

[Keebellah]

I think it's a niussance to enter a password for every tab so I made a small modification.
A named range named 'ALLOWUSER. in Sheet1 range G20 stores the value False when the workbook is first opened.
Once you click a tab and have entered the correct password it will set it to True so during the session you do not need to enter the password every time.
About the properties, I checked and I think it's because Excel interprets the word password and some links in the module as personal data.
I cleaned some and I think its over now.

[Keebellah]

Your stalker again

Try this one, I like it better that hiding rows and so.
In the final version you should then hide the and lock the VBA project

The big button on the first sheet tells you what to do.

Enjoy it and ... happy coding

[Throughstream]

Wow many thanks really appreciate the different versions and the time you've taken on this.

[Throughstream]

Can I make a simple change. When I enter the password in correctly instead of it coming up with the drop down box of which page to go to, can it just go to a specific sheet.

Many thanks

[Throughstream]

Hey I've just been playing with the second version which works great however when I put the password in it unlocks all the columns however I have columns that I want hidden so it's un-hiding those as well.