Password Protecting Validation Lists

  • Thread starter Thread starter Andrew
  • Start date Start date
A

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
 
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
 
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

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
 
I am using 2000
Andrew

Gord Dibben said:
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


Gord Dibben said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top