View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default suddenly can't enter comments

Do you have multiple sheets grouped?

Did you protect the worksheet?

In xl2003, you'd do:
tools|Protection|protect sheet
to protect the sheet

But check the "Edit Objects" to allow commenting.


Berol wrote:

Suddenly I can't enter comments on my worksheet. What do I need to switch on
so I may enter them? Also if I want to keep a worksheet from being accidently
changed by me, as I'm the only person using the computer, how do I to lock
the worksheet but am still able to add and modify comments?


--

Dave Peterson