Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation protection
Is there a way to protect a cell so if there is a validation rule, where only
a value from a list can be entered, you are unable to paste invalid data into this cell. I have tried protectin the workshhet, workbook etc, but it still allows me to copy external data and paste into the column with the validation rule regardless of whether or not it falls in the validation list. Many thanks for your help in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation protection
Pendelfin
You are on the right track! Check to see if the cell is protected, Goto Format cell Protect Check to protect. Next when you place your Data Validation make sure there is a check mark in "Error Alert" tab "Show error alert after invalid data is entered". Now protect the sheet via tools protect. I am using xl2k and this worked for me. Does this help you? Mike Rogers "Pendelfin" wrote: Is there a way to protect a cell so if there is a validation rule, where only a value from a list can be entered, you are unable to paste invalid data into this cell. I have tried protectin the workshhet, workbook etc, but it still allows me to copy external data and paste into the column with the validation rule regardless of whether or not it falls in the validation list. Many thanks for your help in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation protection
Mike
If I protect the cells, where the validation is, then protect the workbook, yes it wont let me paste the data into the cell, but it also wont allow me to select an item from the drop down list. Many thanks "Mike Rogers" wrote: Pendelfin You are on the right track! Check to see if the cell is protected, Goto Format cell Protect Check to protect. Next when you place your Data Validation make sure there is a check mark in "Error Alert" tab "Show error alert after invalid data is entered". Now protect the sheet via tools protect. I am using xl2k and this worked for me. Does this help you? Mike Rogers "Pendelfin" wrote: Is there a way to protect a cell so if there is a validation rule, where only a value from a list can be entered, you are unable to paste invalid data into this cell. I have tried protectin the workshhet, workbook etc, but it still allows me to copy external data and paste into the column with the validation rule regardless of whether or not it falls in the validation list. Many thanks for your help in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Protection | Excel Discussion (Misc queries) | |||
Validation protection with named ranges | Excel Worksheet Functions | |||
data validation and cell protection | Excel Discussion (Misc queries) | |||
Validation & Protection | Excel Discussion (Misc queries) | |||
Data validation, cell protection or other method? | Excel Discussion (Misc queries) |