Thread: Protect cells without protecting the entire workbook.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
curlydave curlydave is offline
external usenet poster
  
Posts: 206
Default Protect cells without protecting the entire workbook.
On Feb 22, 7:48*am, YY san. wrote:
Dear experts,
Is there any VB script of function in Excel to protect certain cells, but no
need to protect the entire worksheet?

Thanks,

Unlock all the cells in the worksheet, then lock the ones you want
protected, then protect the sheet, only the Locked cells are protected.
Reply With QuoteReply With Quote