View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
L. Howard Kittle
 
Posts: n/a
Default Data Validation - Drop Down

Hi John,

I suspect that drop down cell was unlocked before sheet protection was
applied.

To start over unprotect the sheet and select the drop down cell. Under
Format Cells Protection chect the Locked box OK.

Now protect the sheet under Tools Protect Sheet.

I hope I steered you correctly.

HTH
Regards,
Howard

"John" wrote in message
...
How can I "disable" a Drop down list (but still have it in use if the
overall Sheet protection is off)?

I thought it would work via the Sheet Protection, but my sheet is
protected (as are the cells locked where the Drop down is) but I still get
the option of picking from the DV Drop down

Thanks