View Single Post
  #2   Report Post  
tjtjjtjt
 
Posts: n/a
Default

In Excel 2003 you can edit comments in protected sheet, if you check the
option for Edit Objects in the Protect Sheet dialog.
--
tj


"olympiad" wrote:

I have a shared workbook that requires some fields to be used for data entry
and some fields for comments ( using the Xl comment function), however, when
I protect the workbook the overall comment function is also looked (still
allows viewing a previous comment). Is it possible to overcome this scenarion
so that one doesn't have to Unprotect the book or sheet everytime a comment
needs to be inserted or edited.

Many thanks

Olympiad