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