View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default Why can't I edit my comments in Excel?

If the workbook is shared, you won't be able to edit existing comments.
To turn off sharing, choose ToolsShare Workbook
On the Editing tab, remove the check mark from 'Allow changes by more
than one user at a time.'

tfletch wrote:
I'm using Excel 2002 on XP, have been for a couple years and all of a sudden
I cannot edit my comments anymore. I tried right clicking and the toolbar but
I can no longer edit them. Strangely enough this happens with only one
worksheet. I tried copying it, but still the same result. If I add new
comments, I can edit those, just my existing ones I can't edit. Any
suggestions?

Thank you in advance
Todd



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html