View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Is there a way to enter a comment on a locked cell in Excel?

If you protect the sheet, but un-check the objects box, you can allow users
to add comments and still ensure that the sheet is protected from other types
of changes.

Regards,
Ryan---



--
RyGuy


"BJ" wrote:

I am trying to add a comment to a locked cell. I want to keep the cell
locked. Is there a way to enter a comment without unlocking it?