Hi,

It looks like that particular cell or a range comprising that cell has been
protected, Unprotect that cell to use the drop down

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"veggies27" wrote in message
...
I am having trouble choosing items from a drop down list when my sheet is
protected. In the same file I have certain areas where this is not a
problem
at all, but everytime I try to change the cell value via dorp down, or
empty
the cell, I get a "shete is protetced" type error. I thought maybe it had
to
do with the fact that my drop downs are in merged cells, but I unmerged
them
and had the same issue. Any thoughts?