Re: Protecting data validation Drop DownColumn
- From: "nkg" <xyz@xxxxxxxxx>
- Date: Wed, 21 Mar 2007 12:07:09 -0500
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.
"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 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
"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
.
- References:
- Prev by Date: Re: Convert Cell Text to Matching Hyperlink?????
- Next by Date: Re: Reducing data points?
- Previous by thread: Re: Protecting data validation Drop DownColumn
- Next by thread: Create a list and use drop down in other worksheets..possible?
- Index(es):
Relevant Pages
|
