ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   excel 2000 vs excel 2003: locking drop down boxes? (https://www.excelbanter.com/excel-programming/330559-excel-2000-vs-excel-2003-locking-drop-down-boxes.html)

Erik Andreassen

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!


All times are GMT +1. The time now is 09:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com