Protection with working dropdown lists.

[Chaltain]

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?

[Ardus Petus]

Format>Protection
uncheck Locked for your dropdown cells

HTH
--
AP

"Chaltain" <Chaltain@discussions.microsoft.com> a écrit dans le message de
news: F2E48B21-F604-4FC3-98B9-C2F1E2961518@microsoft.com...
> 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?

[John]

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" <Chaltain@discussions.microsoft.com> a écrit dans le message de
> news: F2E48B21-F604-4FC3-98B9-C2F1E2961518@microsoft.com...
> > 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?
>
>
>