Hi everyone

Is there a way of removing validation from a specific cell after a value is
selected from another cell (List).

assume I have a validated "Company" list in Column A and the validated
"Employees Names" listed in column D

eg

After selecting "...Unlisted" from cell A1, can I then using VB to remove
the validation in D1 so I can manually input a name/value in it.

TIA
Mark

Also

could really use help on the following which I posted already, but as yet
have recieved no responses to, just need to know if it is possible.

Example:

If I select XYZ Trans from validated "Company" list in Column A, I would
like the validated "Employees Names" listed in column D to display only the
names of the employees for that company.

Once again
TIA
Mark.