Drop-down Lists and Worksheet Protection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excell 2000 I could set "Validate/Drop down List" for a protected cell and when the worksheet was protected the cell could be "edited" using the drop-down list but not otherwise. Moreover, contents of the cell could be changed but not cleared. Try as I may I can't sem to achieve the same in Excell 2003. Any one have a solution?
 
In Excel 2000, you can select from a data validation list if the source
was a worksheet range, but not if the source was a delimited list.

In Excel 2003, neither is allowed on a protected sheet.

Perhaps you could use a combo box, instead of the data validation dropdown.
 
Thanks, that would work in some applications but not mine where I'm linking the choices made from the drop list to another worksheet. Unless, that is, there is some way to give the combo box an address.

Your interest and reply is appreciated.
 
A combobox has a linkedCell property which you can use to link the
selection to the cell on the other worksheet.
 
Back
Top