Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a file that I want to protect all cells. But at the same time there
are certain cells that have a Data Validation Dropdown where I want the user to be able to select an item off the dropdown list and update the cell. I want to protect everything because I do not want anyone to be able to "Paste" anything in the file or make any changes in the file except for making selections from the Data Validation Dropdown and no other way. For example: The cells that have dropdowns must be in protected mode when user enters the cell because I do not want the user to be able to take a cell from somewhere else and copy / paste over the Data Validation Cell I have setup. Therefore I need the protection as mentioned above. How can I accomplish this? Thank you for your help. Steven |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data validation with dropdown list | Excel Discussion (Misc queries) | |||
Dropdown lists from datavalidation. | Excel Discussion (Misc queries) | |||
Protect Data validation cells from copy paste | Excel Discussion (Misc queries) | |||
Data Validation Dropdown bug | Excel Programming | |||
Data Validation Calender Dropdown | Excel Programming |