A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Edit Comment" Broken in Excel 2002 SP2



 
 
Thread Tools Display Modes
  #1  
Old October 14th, 2004, 05:29 AM
Gary Johnson
external usenet poster
 
Posts: n/a
Default "Edit Comment" Broken in Excel 2002 SP2

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.


  #2  
Old October 14th, 2004, 12:00 PM
David McRitchie
external usenet poster
 
Posts: n/a
Default

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
--
---
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" Gary wrote in message ...
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.




  #3  
Old October 14th, 2004, 12:08 PM
David McRitchie
external usenet poster
 
Posts: n/a
Default

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


  #4  
Old October 14th, 2004, 05:13 PM
Gary Johnson
external usenet poster
 
Posts: n/a
Default

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" wrote:

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



  #5  
Old October 14th, 2004, 05:23 PM
David McRitchie
external usenet poster
 
Posts: n/a
Default

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" wrote in message ...
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" wrote:

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






  #6  
Old October 14th, 2004, 06:13 PM
Gary Johnson
external usenet poster
 
Posts: n/a
Default

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" wrote:

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" wrote in message ...
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" wrote:

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







 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Windows in Taskbar Chevy General Discussion 8 October 15th, 2004 03:57 PM
Excel 2000 vs 2002 Sheet protection & Validation cells Andre Croteau General Discussion 4 July 17th, 2004 03:31 PM
Edit Formula in Excel 2002 gsomerse Setting up and Configuration 1 June 17th, 2004 11:23 PM
Excel 97 to Excel 2002 Dean Setting up and Configuration 4 October 17th, 2003 05:08 PM


All times are GMT +1. The time now is 02:54 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.