I am not sure if this is the right forum but I have a question about somehow
protecting the data validation (drop down list) in excel. I dont want the
user to delete the cell and the validation. I just want the user to edit the
cell. Is this possible? Thanks

"T. Valko" wrote:

Glad you got it straightened out. Thanks for letting us know.

--
Biff
Microsoft Excel MVP


"Jeff H." wrote in message
...
As I was looking around my spreadsheet I found my problem. when you
mentioned
something about cells not contain the same validation I noticed cells J1 &
J2
do not contain data validation. They are used as labels for the column. I
guess that would be the reason for the message. This is the first time I
received it with excel 2000.

Your solution with the dynamic name range solved my problem. I've have
applied it to my workbook and all 12 sheets work correctly. Now I can add
or
remove names in one location and it auto updates the list in all 12
sheets.

Thanks again, you have been very helpful

"T. Valko" wrote:

In brand new files with the exact same setup I can't reproduce that
behavior
in either Excel 2002 or 2007 (all SPs installed).

Everything works as expected.

Hmmm....


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Interesting. I've never experienced that.


--
Biff
Microsoft Excel MVP


"Debra Dalgleish" wrote in message
...
And occasionally you'll get that warning message even if the data
validation is all the same. There's a sample file he

http://www.contextures.com/xlDataValSame.html


T. Valko wrote:
Is this the message that you're seeing:

http://img503.imageshack.us/img503/3...messagerx3.jpg

That happens if you select a range of cells and the data validation
is
not the same in all of the selected cells.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html