View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris Chris is offline
external usenet poster
 
Posts: 788
Default Protection of a Drop Down List

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?