Editing Comments

p.s. - the worksheets are not grouped, the display properties are set at
comment indicator only, the problem exists on this file on multiple PCs and
persists when portions of the sheet are copied to new blank workbooks, but
does extend to other workbooks which include extensive comments. Appears
limited to this workbook only (for now).

"Lady G" wrote:

I am also having this problem. My workbook is not protected (but it is
shared). Older comments (not Data Validations) must be shown before they can
be edited. Some newer ones still seem to retain the one-right-click access.
Right click, edit comments does not have any effect on the older comments
(nor does going in through the view menu), but I have been unable to
determine exactly how far back this goes with regards to when the comments
were created. My workbook contains at least a thousand comments (making me
loathe to recreate one by one). Any ideas on why the edit comment function
would cease to work?

Better still, any ideas on how to automate a fix and avoid this problem in
the future?



"CLR" wrote:

Ok, then that pretty clearly indicates that the trouble is within that one
file itself. If you don't get an answer that solves it, you may have to
result to re-creating the entire workbook......(sometimes the Dragon
wins)......try copying it out one sheet at a time to a new workbook and check
each time to see if the trouble transfers to the new file......when it does,
you may be able to narrow it down to one sheet.

hth
Vaya con Dios,
Chuck, CABGx3



"Please Help" wrote:



"CLR" wrote:

Could the ones you can't edit actually be DataValidation InputMessage boxes
rather than CommentBoxes?

No Definately Comment Boxes

Does the problem exist if you open the file on another computer?

Yes

Do you have the same problem with other files on this same computer?

No

Vaya con Dios,
Chuck, CABGx3



"Please Help" wrote:

I wondered if any one could tell me why I cant edit a comment that has been
made allready on my excel spreadsheet I can add in new ones and edit them but
any older ones i cant.

P.S. In the interests of efficiency: the worksheets are not grouped; the
display properties are set at comment indicator only; the problem exists on
this file on multiple PCs and persists when portions of the sheet are copied
to new blank workbooks, but does extend to other workbooks which include
extensive comments. Appears limited to this workbook only (for now).


"Lady G" wrote:

I am also having this problem. My workbook is not protected (but it is
shared). Older comments (not Data Validations) must be shown before they can
be edited. Some newer ones still seem to retain the one-right-click access.
Right click, edit comments does not have any effect on the older comments
(nor does going in through the view menu), but I have been unable to
determine exactly how far back this goes with regards to when the comments
were created. My workbook contains at least a thousand comments (making me
loathe to recreate one by one). Any ideas on why the edit comment function
would cease to work?

Better still, any ideas on how to automate a fix and avoid this problem in
the future?



"CLR" wrote:

Ok, then that pretty clearly indicates that the trouble is within that one
file itself. If you don't get an answer that solves it, you may have to
result to re-creating the entire workbook......(sometimes the Dragon
wins)......try copying it out one sheet at a time to a new workbook and check
each time to see if the trouble transfers to the new file......when it does,
you may be able to narrow it down to one sheet.

hth
Vaya con Dios,
Chuck, CABGx3



"Please Help" wrote:



"CLR" wrote:

Could the ones you can't edit actually be DataValidation InputMessage boxes
rather than CommentBoxes?

No Definately Comment Boxes

Does the problem exist if you open the file on another computer?

Yes

Do you have the same problem with other files on this same computer?

No

Vaya con Dios,
Chuck, CABGx3



"Please Help" wrote:

I wondered if any one could tell me why I cant edit a comment that has been
made allready on my excel spreadsheet I can add in new ones and edit them but
any older ones i cant.

(using Office excel 2003) I've been struggling with same "Locked Comments"
problem. Two solutions worked: 1) copied my three worksheets to a new
workbook, where comments can be edited as usual (right click method)...and
then went back to original workbook:
2) I discovered I had coded the original workbook as "shared"...once
removed, comments could be edited normally.
[ to check/remove "shared" designation: click TOOLS, then SHARED WORKBOOK,
then on the "editing" tab, and UNcheck the box ("allow changes by more than
one user...") and click OK.] Hope it works.
PB

"Lady G" wrote:

P.S. In the interests of efficiency: the worksheets are not grouped; the
display properties are set at comment indicator only; the problem exists on
this file on multiple PCs and persists when portions of the sheet are copied
to new blank workbooks, but does extend to other workbooks which include
extensive comments. Appears limited to this workbook only (for now).


"Lady G" wrote:

I am also having this problem. My workbook is not protected (but it is
shared). Older comments (not Data Validations) must be shown before they can
be edited. Some newer ones still seem to retain the one-right-click access.
Right click, edit comments does not have any effect on the older comments
(nor does going in through the view menu), but I have been unable to
determine exactly how far back this goes with regards to when the comments
were created. My workbook contains at least a thousand comments (making me
loathe to recreate one by one). Any ideas on why the edit comment function
would cease to work?

Better still, any ideas on how to automate a fix and avoid this problem in
the future?



"CLR" wrote:

Ok, then that pretty clearly indicates that the trouble is within that one
file itself. If you don't get an answer that solves it, you may have to
result to re-creating the entire workbook......(sometimes the Dragon
wins)......try copying it out one sheet at a time to a new workbook and check
each time to see if the trouble transfers to the new file......when it does,
you may be able to narrow it down to one sheet.

hth
Vaya con Dios,
Chuck, CABGx3



"Please Help" wrote:



"CLR" wrote:

Could the ones you can't edit actually be DataValidation InputMessage boxes
rather than CommentBoxes?

No Definately Comment Boxes

Does the problem exist if you open the file on another computer?

Yes

Do you have the same problem with other files on this same computer?

No

Vaya con Dios,
Chuck, CABGx3



"Please Help" wrote:

I wondered if any one could tell me why I cant edit a comment that has been
made allready on my excel spreadsheet I can add in new ones and edit them but
any older ones i cant.