View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris Chris is offline
external usenet poster
 
Posts: 788
Default Can I protect data in a cell, but allow comments to be entered.

Hi All,
I have an excel sheet in which I have some protected cells and
unprotected cells. The protected cells are protected so that the forumla
within them cannot be edited/removed, however, I would like all users to be
able to insert comments in these fields.
The edit objects selection when protecting the sheet allows for comment
entry, but it also allows the user to alter the data in the cell.
Any solutions/ advise on this would be greatly appreciated.

Many Thanks

Chris