Re: Protecting data validation Drop DownColumn

thx. Ron, Here is what iam trying to do
I want to build a template kind of *** 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.

"Ron Coderre" <RonCoderre@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:86849433-B4E4-4918-A693-236BEB92BD65@xxxxxxxxxxxxxxxx
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 *** (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


"nkg" wrote:

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





.