Protecting data validation Drop DownColumn

[nkg]

I made a column which displays only dropdown lists made from
datavalidation. When i copy and paste cells over it
the dropdowns are no longer available. Is there a way to protect the column
? thx

 

[Guest]

See if this works for you....

With cell A1 having the Data Validation
Set these protection options:
A1 is UN-locked
B1 is LOCKED

Merge A1:B1
Protect the sheet (with or without a password)

End result:
The merged cells (effectively A1) can be edited
but...can't be cleared with the [delete key]
and...you can't paste (or paste special) over it.

The only way to erase the contents is to:
Edit the cell
Select the contents
Then press [delete]

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP

 

[Dave Peterson]

Don't just Paste, do a paste special|Values.

Pasting will remove the data|validation rules.

 

[nkg]

thx. Ron, Here is what iam trying to do
I want to build a template kind of sheet with couple of drop down columns
having lookups like state,color
I don't want the user to modify these column drop down properties but may
leave it blank.
I belive that's what you mentioned in your last statement. thx.

See if this works for you....

With cell A1 having the Data Validation
Set these protection options:
A1 is UN-locked
B1 is LOCKED

Merge A1:B1
Protect the sheet (with or without a password)

End result:
The merged cells (effectively A1) can be edited
but...can't be cleared with the [delete key]
and...you can't paste (or paste special) over it.

The only way to erase the contents is to:
Edit the cell
Select the contents
Then press [delete]

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP

I made a column which displays only dropdown lists made from
datavalidation. When i copy and paste cells over it
the dropdowns are no longer available. Is there a way to protect the
column
? thx