View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
EdMac
 
Posts: n/a
Default Protected sheet accepting values from List


Check if the cell with the list in it is protected and when you protect
the sheet make sure you uncheck the box 'select locked cells'

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=512068