Data validation - prevent cell overwrite
 

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

Data validation - prevent cell overwrite
 

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

Data validation - prevent cell overwrite
 

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

Data validation - prevent cell overwrite
 

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