List and Data Validation
 

What we'd like to do is be able to add text to whatever drop down value we
choose to drop into a cell in those columns. Right now, once you select a
drop down value and then try to add to it, Excel gets says "a user has
restricted values in this cell." If we can select a drop down value ... and
then modify it a little, we can remove columns C and F from our spreadsheet.

List and Data Validation
 

Datavalidationerror alert

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Erika" wrote in message
...
What we'd like to do is be able to add text to whatever drop down value we
choose to drop into a cell in those columns. Right now, once you select a
drop down value and then try to add to it, Excel gets says "a user has
restricted values in this cell." If we can select a drop down value ...
and
then modify it a little, we can remove columns C and F from our
spreadsheet.