Greetings,
Is there any way to prevent a user from removing data validation from a cell
by pastiing another cell's contents into it
Many Thanks

Nope.

Well, train them not to...

Maybe you could put your rules into an event procedure--but they could disable
macros or turn of events.

David wrote:
>
> Greetings,
> Is there any way to prevent a user from removing data validation from a cell
> by pastiing another cell's contents into it
> Many Thanks

--

Dave Peterson

Only by locking the cell and applying sheet protection.

You can get finer control on what is allowed on a protected sheet in xl2002
and later.

--
Regards,
Tom Ogilvy


"David" wrote:

> Greetings,
> Is there any way to prevent a user from removing data validation from a cell
> by pastiing another cell's contents into it
> Many Thanks

Tom,
Thanks for your answer...
I am working with excel 2002
I've looked at the options associated with worksheet protection but cannot
see a way to do what I want, which is to:
allow a user to edit a form, mainly cells with data validation, but stop the
user from either changing/deleting the data validation by copy & paste from
elsewhere on the form. Also I would like to retain the formatting of the form
so that the user cannot copy & paste a formats from elsewhere on the form.
Maybe I need to disable the copy/paste function? Is there a way?
Thanks again

"Tom Ogilvy" wrote:

> Only by locking the cell and applying sheet protection.
>
> You can get finer control on what is allowed on a protected sheet in xl2002
> and later.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "David" wrote:
>
> > Greetings,
> > Is there any way to prevent a user from removing data validation from a cell
> > by pastiing another cell's contents into it
> > Many Thanks