Thread: Protect cells without protecting the entire workbook.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Protect cells without protecting the entire workbook.
No

Cell protection requires Worksheet Protection be enabled.

Provide a description of what you would like to do.

The usual method is to unprotect, do the deed then re-protect.


Gord Dibben MS Excel MVP

On Sun, 22 Feb 2009 06:48:06 -0800, 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,

Reply With QuoteReply With Quote