Password Protecting Validation Lists

[Andrew]

It seems as though when you password protect a worksheet it still allows
another user to change the intial selection selected when using Data
Validation and allowing a specific entry as per a predefined List. Is there
anyway to prevent changes to a Data Validation selection after protecting
the worksheet???

Any thoughts would be helpful.
Andrew

 

[Gord Dibben]

Andrew

If the cell with the Data Validation drop-down list is locked, users cannot
change the selection when sheet is protected.

Gord Dibben Excel MVP

 

[Andrew]

You are correct that you can NOT overwrite what is in the Protected cell,
HOWEVER, you can still click on the arrow which brings up the list and
allows you to change the selection. Is there any way to prevent this, other
than removing the Validation??

Andrew

 

[Gord Dibben]

Andrew

Which version of Excel are you running?

2002 and 2003 will not allow a change of selection or overwrite if the arrow
is clicked while the cell is locked and worksheet is protected.

Haven't tested 97 but believe it was the same.

Gord

 

[Andrew]

I am using 2000
Andrew

Andrew

Which version of Excel are you running?

2002 and 2003 will not allow a change of selection or overwrite if the arrow
is clicked while the cell is locked and worksheet is protected.

Haven't tested 97 but believe it was the same.

Gord

You are correct that you can NOT overwrite what is in the Protected cell,
HOWEVER, you can still click on the arrow which brings up the list and
allows you to change the selection. Is there any way to prevent this, other
than removing the Validation??

Andrew

Andrew

If the cell with the Data Validation drop-down list is locked, users cannot
change the selection when sheet is protected.

Gord Dibben Excel MVP