"Edit Comment" Broken in Excel 2002 SP2

G

Gary Johnson

When I "right-click" and "Edit Comment" in a cell with an existing comment,
nothing happens, i.e. the comment does not open for editing. Similarly for
the Edit Comment icon in the Reviewing toolbar.

Hover works, i.e. displays the comment.
The only way I can edit the comment is to Show Comment first.
However, I have to re-hover over the cell to get the Comment to pop-up.

Anyone run into this problem before? I did not find this problem described
in the Knowledge area.
 
D

David McRitchie

If you are indicating you do not get your right click menu (context menu)
=
you can put the following in a regular macro or you can use it from the intermediate window
to restore use of the right click cell menu w

Application.Commandbars("cell").Enabled = True
--
 
D

David McRitchie

If that was not the answer you were looking for:
can you insert a comment from the Insert menu (at the top)
 
G

Gary Johnson

Actually, the "right-click" pop-up menu works fine, and the comment in the
cell is already there. I just can no longer "Edit Comment" from either the
"right-click" menu or from the toolbar.
 
G

Gary Johnson

Hi David, twas a good thought... but not the source of the problem.
Protection was not turned on. Thank you for taking your time to think about
this.
Gary

David McRitchie said:
Hi Gary,
Sounds like you have sheet protection turned on, for which
you would see the menu item, but it would be grayed out.
http://www.mvps.org/dmcritchie/excel/grayedout.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Gary Johnson said:
Actually, the "right-click" pop-up menu works fine, and the comment in the
cell is already there. I just can no longer "Edit Comment" from either the
"right-click" menu or from the toolbar.
Click to expand...
Click to expand...
 
Top