View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Protected Excel Lists....HELP! Protected Excel Lists....HELP! is offline
external usenet poster
 
Posts: 1
Default Excel Lists in a Protected Spreadsheet

I am creating a couple of spreadsheets in Excel in which most cells are
locked. I need another user to be able to add data to the list and that's it
(hence the locked cells). Once I protect the worksheet I am not able to add
to the list and i really need the workbook to be protected