View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
davesexcel
 
Posts: n/a
Default How to allow all users to make changes to unlocked cells on WrkSh


unhide the cells that you want data inputted into, then protect the
sheet,
select the cells that data changes, goto format cells, protection,
uncheck hide, then protect the sheet


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=523983