Protection with working dropdown lists.

What I am trying tp do is protect a worksheet but allow drop down list to
work properly. What is the best way to accomplish this?

Format>Protection
uncheck Locked for your dropdown cells

HTH
--
AP

"Chaltain" <[email protected]> a écrit dans le message de
news: [email protected]...
> What I am trying tp do is protect a worksheet but allow drop down list to
> work properly. What is the best way to accomplish this?

I don't think so, it's work. I also facing this problem. I uncheck locked my
dropdown cells, still could not open dropdown cell.

JOHN

"Ardus Petus" wrote:

> Format>Protection
> uncheck Locked for your dropdown cells
>
> HTH
> --
> AP
>
> "Chaltain" <[email protected]> a écrit dans le message de
> news: [email protected]...
> > What I am trying tp do is protect a worksheet but allow drop down list to
> > work properly. What is the best way to accomplish this?
>
>
>