"Edit Comment" Broken in Excel 2002 SP2

[Guest]

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.

 

[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
--

 

[David McRitchie]

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

 

[Guest]

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.

 

[David McRitchie]

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

 

[Guest]

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