View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Erik Andreassen Erik Andreassen is offline
external usenet poster
 
Posts: 1
Default excel 2000 vs excel 2003: locking drop down boxes?

Hi,

I've been using drop down boxes in an excel 2003 worksheet. In 2003, I am
able to lock the cell with the drop down box and protect the worksheet, which
then prevents anyone from selecting a new value from the drop down boxes and
changing the contents of that cell. However, when I try the same procedure
in excel 2000, the drop down box never locks, and can still allow new
selections from the box. Does anyone know of a workaround for this, or is
this just a flaw in 2000? Thanks!