| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to stop info from being pasted into a cell that has a drop dow
I need to prevent someone from overwiting information in a cell that has a
drop down box of items to choose from by not allowing them to paste information they copied from other spreadsheets. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to stop info from being pasted into a cell that has a drop dow
Use Data Validation...
"lorettal" wrote: I need to prevent someone from overwiting information in a cell that has a drop down box of items to choose from by not allowing them to paste information they copied from other spreadsheets. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to stop info from being pasted into a cell that has a drop
You can still paste over DV, no matter the DV (at least in xl2003). There
really isn't a practical way to prevent it. -- John C "Sheeloo" wrote: Use Data Validation... "lorettal" wrote: I need to prevent someone from overwiting information in a cell that has a drop down box of items to choose from by not allowing them to paste information they copied from other spreadsheets. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How stop Excel default display of pasted number as scientific equa | Excel Worksheet Functions | |||
| How do I stop the cell from becoming a drop down box when editing | Excel Discussion (Misc queries) | |||
| Need a Drop Tab that when selected, auto filters info to a cell!!! | Excel Discussion (Misc queries) | |||
| Need a Drop Tab that when selected, auto filters info to a cell!!! | Excel Discussion (Misc queries) | |||
| Create form that can't be chg'd but info can be copied/pasted? | Excel Discussion (Misc queries) | |||
Linear Mode
