List, Data Validation, unlocked cell, protected sheet.....

K

Kane

I have a unlocked cell, with Data Validation, List. With sheet protection
activated I cannot "add" to the cell contents supplied from the List
function. If sheet protection is off, this is possable. Is there a way to
have this feature with sheet protection turned on (activated)?
 
J

JulieD

Hi Kane

are you saying that in say cell A1 you have a drop down list created via
data validation ... you're clicked on this cell and chosen format / cells /
protection - and unchecked locked
and then when you choose tools / protection / protect sheet you can't make a
selection from the drop down list in A1?

if so, this is definitely not the standard behaviour of excel, so:
what version / service packs etc (help / about microsoft excel)?
if you test the same scenario in a new workbook what happens?
is there anything odd or unusual about the list (is it create using a range
name, or have you typed the entries into the source line in the data /
validation dialog box - not that it should make a difference)?

Cheers
JulieD
 
K

Kane

Julie... XL2K,sp3
Last assumption is wrong. after protect sheet, I can make cell selection
from the list, but after I have made that, I would like to be able to enter
additional comments in that cell. If the sheet is not protected, I can do
this! I need sheet protection activated.

Rgds .... Kane
 
K

Kane

Debra..
All 13 sheets in the workbook must be protected. Is what you say still
applicable?

Tks ... Kane
 
D

Debra Dalgleish

Perhaps you could insert a new sheet into the workbook, and enter the
list on that sheet. Leave it unprotected, so new items can be added.
 
K

kalpanaganeshm

Informatics Outsourcing is an Offshore Data Management service company. Data Management Service includes all types of Data Conversion, File Conversion, XML Conversion, HTML Conversion,SGML Conversion, Document Conversion,DataEntry, Data Extraction and Validation,OCR and ICR Services with affordableprice. Our team to give the solution quickly and given requirements.
 

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

Top