Protection changed its behavior in xl2003 (or was it in xl2002???).

You have to unlock that cell in xl2003.



Steve wrote:

I have an excel sheet that the first column contains drop downs to select a
code from another tab. I used Insert / Name / Define to choose the list.

I have tried to lock every cell and protect the sheet and every cell works
fine except where I have the drop downs. What is odd is that even the drop
down cells are locked on my Excel (2003) but when I email it to my client
(uses Excel 2000) it is not locked and he can click the drop down and choose
codes.

Please help - thanks!

-Steve

--

Dave Peterson