Thread: To allow edit of particular rows and protect other rows from editi
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CaptainQuattro
 
Posts: n/a
Default To allow edit of particular rows and protect other rows from editi

Before turning on Sheet protection with Tools Protection Protect
Worksheet

Select the cells that you want to allow input to, and select Format
Cells Protection and uncheck "Locked."

No when you do Tools Protection Protect Sheet, the selected cells
will remain open for user input.





DHANRAJ Wrote:
I would like to protect a Excel WorkSheet and at the same time allow
only
particular rows or columns for editing or data entry. How this can be
done?


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=527929

Reply With QuoteReply With Quote