Passwords and drop down lists
How would I write a marco that requires a password when a certain word in a drop down list is selected, bearing in mind that when this word is selected certain cells in the worksheet are no longer locked - in other words the certain cell can only changed by a specific person in the drop down list which when this person is selected a password is required.
Hope that made sense.
Many thanks
SO, all that you want to happen is that when "John Doe" is selected in a certain cell, the sheet immediately asks you for a password. If the password entered is correct, it allows "John Doe" to be selected and does nothing else.
If the wrong password is selected, in indicates "wrong password" and removes the name "John Doe" from the cell.
Is that all? What's the cell?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
What kind of drop down box are you using?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I am using a validation drop down list. When a certain name is selected from the list I need a password prompt. once the person enters the correct password certain cells should be free for editing - with the other names in the drop down list the sheet should remain locked ( apart from the cells they are allowed to edit ) - in other words the person that is password protected has more acress rights and can edit an extra cell.
Many thanks
I would create Named Ranges based on the names in the list that can be locked or unlocked as required, then use the worksheet_change event. If you need help with this then attach an example workbook
Re: Passwords and drop down lists
Many thanks
I've added two named ranges - Bob & Claire.
The code unlocks the selected range if the password is correct. Selecting a cell out of that range relocks the cells
look at the code for the passwords.
Re: Passwords and drop down lists
Thank you very much, but is the password secret, because I cant seem to get it to work.
The passwords are in the code.
The sheet password is secret
Bob is x
Claire is y
I get a runtime 1004 error
It works for me. I've only added Bob & Claire.
What exactly are you doing? When you select the name in the yellow cell your are prompted for a password - Bob is x. You can then edit Bob's cells. When you select a different cell not in Bob's cells the cells are locked again
Ok it works now, is there a way to change or get rid of the error message that comes up when you try to edit a cell
Do you mean the one that tells you that the sheet is protected? That is an inbuilt Excel message. You can stop it by usingOriginally Posted by NatNat
I wouldn't bother though because you will need to reset it.
Please Login or Register to view this content.
Where would I put
Application.DisplayAlerts = True
In the code
Near the very top is where I put all my declarations (DIM) and Application.Whatever code.
Application.DisplayAlerts will not stop that error message
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks