Message-ID:

A year spent in artificial intelligence is enough to make one believe in God.

computers / microsoft.public.excel.misc / Re: Protect validation but allow drop down selection

Re: Protect validation but allow drop down selection

<d420e00b-e892-4fe8-8e79-d374fd87f5ben@googlegroups.com>

https://www.novabbs.com/computers/article-flat.php?id=540&group=microsoft.public.excel.misc#540

copy link Newsgroups: microsoft.public.excel.misc

X-Received: by 2002:a05:6214:23c6:b0:491:99e3:80ce with SMTP id hr6-20020a05621423c600b0049199e380cemr1545220qvb.111.1662524362417;
Tue, 06 Sep 2022 21:19:22 -0700 (PDT)
X-Received: by 2002:a37:2796:0:b0:6be:7674:7f88 with SMTP id
n144-20020a372796000000b006be76747f88mr1421708qkn.470.1662524362223; Tue, 06
Sep 2022 21:19:22 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: microsoft.public.excel.misc
Date: Tue, 6 Sep 2022 21:19:22 -0700 (PDT)
In-Reply-To: <180E8896-F896-4548-BBD2-3B8620183B2B@microsoft.com>
Injection-Info: google-groups.googlegroups.com; posting-host=116.87.134.24; posting-account=_HUCiwoAAADKxiAQQm3HhrQB7lZWTsrz
NNTP-Posting-Host: 116.87.134.24
References: <AcohjS/YWtCeUYq4RgWY7f1zODQxMA==> <4C828907-27FB-497F-A6EC-A7DEAC5A580D@microsoft.com>
<180E8896-F896-4548-BBD2-3B8620183B2B@microsoft.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <d420e00b-e892-4fe8-8e79-d374fd87f5ben@googlegroups.com>
Subject: Re: Protect validation but allow drop down selection
From: finesthh...@gmail.com (finest hhelper)
Injection-Date: Wed, 07 Sep 2022 04:19:22 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 2195

by: finest hhelper - Wed, 7 Sep 2022 04:19 UTC

On Thursday, August 20, 2009 at 7:56:01 PM UTC+8, Eduardo wrote:
> Hi,
> you can protect your workbook not allowing anybody to change you validation
> settings. you can give access to the whole spreadsheet but the validation.
> Highlight all the cell you want the user to enter information, right click in
> the mouse, format cells, Protection, uncheck locked, be sure that your
> validation list is locked, then protect the sheet
> if this helps please click yes, thanks
> "Paul07" wrote:
> > Hi
> > I would like to allow users of my spreadsheet to select from a drop down
> > list in cells but would like to prevent changes to the validation settings
> > for the cell.
> >
> > I am finding that people copy>paste and the validation settings for the
> > copied cells are added to the pasted cell.
> >
> > Any help?
> >
> > Cheers
> >
Does this (protecting worksheet) prevent all users from using the filter function?

Subject	Author
Re: Protect validation but allow drop down selection	finest hhelper