Protection of a Drop Down List

C

Chris

I've created a spreadsheet with drop down lists reflecting people with
certain qualifications. As a supervisor I'd like to give my lower-level
supervisors the authority to use the drop down lists but not have the ability
to copy and paste certain cells over others. How do I protect drop down lists
so they can be used but not copied and pasted?
 
Top