ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell protection - drop down list (https://www.excelbanter.com/excel-discussion-misc-queries/96778-cell-protection-drop-down-list.html)

Helmut

Cell protection - drop down list
 
I have worksheet with several drop-down lists. selecting from dropdown fills
another cell.
both cells are 'unprotected'
BUT I don't want anyone to override either the dropdown-list nor the cell to
be filled.
How do I protect the two cells and allow the values of the dropdownlist and
filled cell to be filled when selecting from the dropdownlist?
Helmut


All times are GMT +1. The time now is 11:34 PM.

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