Cell protection - drop down list

H

Helmut

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Drop down lists in seperate columns 5
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
how to add a combolist drop down to each row 2
Link a text box based on drop down box with four options MS Word 365 0
How do I designate dates using info from a cooresponding drop down list? 3

Top