Password Protection

  • Thread starter Thread starter Gaurab
  • Start date Start date
G

Gaurab

I have a password protected sheet. For one of the
columns, I have a validation rule and have a list of
values that the column can take.

I put a password for the sheet and now no can change the
sheet except for the column where I have the validation
rule. When I click on that column, the small arrow
appears and the drop down box appears and I can select a
different value and change the cell. All other columns
are locked.

Cant we protect a column that has a validation rule with
a "List" as option?
 
Not that I'm aware.

But doesn't the Data|Validation provide the same "protection" as a locked cell
on a protected worksheet.

(yeah, Data|Validation can be broken by pasting, but worksheet protection can be
broken pretty easily, too.)
 
Back
Top