yes it is protected from "key strokes" but not from the "Mouse clicking the
drop down menu and changing the value" therefore it is not actually protected.

I feel this may be Excel settings.

How about an exchange of emails and I can show you with screen shots I
really appreciate your help with this.

my email is (right spelling just copy and paste)

Andrew


"Otto Moehrbach" wrote:

Andrew
What you say is a paradox. You say that if the sheet is protected, no
one can select a different value in the DV cell, and then you say they can
still change the value in the DV cell.
If the sheet is protected, the user cannot change the value in a DV cell
(in my 2002 version of Excel), so you don't need anything. If the sheet is
not protected, or that cell is Unlocked and the sheet is protected, then the
user CAN change the value in that cell. That's when you need the
Worksheet_SelectionChange macro to deny the user access to the list without
a password. Post back and clarify what it is that you want to do. HTH
Otto
"Andrew" wrote in message
...
Sorry it is hard to explain.

I can lock the spreadsheet which means if I type in any cell it wont let
me
change the value, this will also stop me changing the value in a cell from
a
validation list. However although this protects the spreadsheet from
keystrokes it does not stop any one can click on the arrow of the
validation
list and change the value. Therefore bypassing the password protection
(accidently)

My question is can i put a password on the small arrow on the validation
list so that the list is password protected?

Or do you have a different method?

Andrew


"Otto Moehrbach" wrote:

Andrew
You have 2 questions that are not related. The first asks how to
prevent access to the DV cell and the second asks how to protect the cell
AFTER a selection has been made from the DV list. Did you mean to ask
those
2 questions?
For the first, you can use a Worksheet_SelectionChange event macro.
You
can write code into that macro to first negate the selection, then ask
for a
password, then reselect that cell if the right password is given.
I don't know what you mean in your second question. What action by
the
user do you want the user to not be able to do with that cell?
Be aware that Excel is not intended to be a secure platform, and it
isn't. Anyone with the right knowledge can break any security scheme you
come up with. HTH Otto
"Andrew" wrote in message
...
Hi

I would like to know how I could password protect a validation list.

In more detail what I would like is when I click on the cell with the
drop
down menu a password is asked before the menu appears.

OR

Any other method to protect a cell once you have selected your
information
from the drop down menu.

Andrew