| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - Prevent delete | Excel Discussion (Misc queries) | |||
| How to prevent copy/paste of cell with validation? | Excel Programming | |||
| Data validation to prevent duplicate entry. | Excel Discussion (Misc queries) | |||
| Prevent duplicate in Data Validation | Excel Programming | |||
| prevent duplicate in Data Validation | Excel Programming | |||
Hybrid Mode
