View Single Post
  #2   Report Post  
Springbok
 
Posts: n/a
Default

Hi,

Is the drop down list part of validation / combo box? If it is is it linked
to a list in an array in the same workbook? You can protect it by locking
the cells that make up the list array. Then apply worksheet protection.

Cheers,
Jon

"kfutbol" wrote:

When protecting a sheet, I know you can prevent changes to cell content but
how can you prevent a change in a drop down list? Once I protect the sheet,
I can still change a drop down list. How can I prevent this? Thank you!