View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steven steven is offline
external usenet poster
 
Posts: 389
Default Protect all cells but allow data validation dropdown change

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