Can't Edit comments (XL 2007)

[TomCon]

Mysterious. On ONE SHEET only; other sheets it works in normal fashion. I
have comments for cells in this sheet. When i select the cell with the
comment, and go to the Review, Edit Comment button, it does not behave
"normally". Normally, clicking "Edit comment" brings up the comment, and
focus is in the comment so it can be edited. On this sheet, clicking "edit
comment" does not bring up the comment and put focus in it. Instead, it is
as if "edit comment" had not been clicked. Basically, if i then move mouse
back to that cell, comment pops up in 'normal' fashion as "read-only" with
no focus such that it can be edited. Very reproducible for all comments on
this sheet, but all other sheets work correctly and normally and comments
are editable.

What can be done about this? (Major problem; this sheet has lots of
comments that need to be edited).

Thanks,
tom

 

[Niek Otten]

Hi Tom,

Is the sheet protected?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Mysterious. On ONE SHEET only; other sheets it works in normal fashion. I
| have comments for cells in this sheet. When i select the cell with the
| comment, and go to the Review, Edit Comment button, it does not behave
| "normally". Normally, clicking "Edit comment" brings up the comment, and
| focus is in the comment so it can be edited. On this sheet, clicking "edit
| comment" does not bring up the comment and put focus in it. Instead, it is
| as if "edit comment" had not been clicked. Basically, if i then move mouse
| back to that cell, comment pops up in 'normal' fashion as "read-only" with
| no focus such that it can be edited. Very reproducible for all comments on
| this sheet, but all other sheets work correctly and normally and comments
| are editable.
|
| What can be done about this? (Major problem; this sheet has lots of
| comments that need to be edited).
|
| Thanks,
| tom
|
|