Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have created a form using data validation drop-downs for most of my input
fields and then protected the spreadsheet allowing edits to selected fields. The problem I have is that you can copy & paste values on top of the drop-downs without getting an error. Is there a way to ensure that a user ONLY selects from a list in a drop-down while still allowing a cell or 2 to be available for free text? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Data Validation | Excel Worksheet Functions | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |