Ken
I don't follow all of that. Do this. Unprotect the sheet. Select the
Data Validation cell and set it to unlocked. Protect the sheet. The DV
cell should function normally. HTH Otto
"Ken Curtis" wrote in message
...
Although I have set its properties (FormatCellsProtectionUnlock) to
"Unlocked", List drop downs (situated above likewise unlocked cells in a
colum) will not function in a sheet that is otherwise locked.
Ideas?
--
Ken Curtis