software

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

Is your worksheet protected?

Do you have multiple worksheets grouped?
--
Richardquot;tfletchquot; wrote:

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


what happens when you right click the the cell, all you say is that you
can't edit them, what appears,
First thing I thought of was well ... did you use data validation and
not the cell comments for some of those cells??,
Of course I can't tell because all you said was that you couldn't edit
them...--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=543925Richard : I don't have my worksheet protected or grouped
davesexcel : I get all my normal options when I right click, and when I
click on edit nothing at all happens. I did definitely use the insert comment
when they were created.quot;tfletchquot; wrote:

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

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

tfletch wrote:
gt; I'm using Excel 2002 on XP, have been for a couple years and all of a sudden
gt; I cannot edit my comments anymore. I tried right clicking and the toolbar but
gt; I can no longer edit them. Strangely enough this happens with only one
gt; worksheet. I tried copying it, but still the same result. If I add new
gt; comments, I can edit those, just my existing ones I can't edit. Any
gt; suggestions?
gt;
gt; Thank you in advance
gt; Todd--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html