When editing comments in Microsoft Excel 2007 by right clicking and choosing “Edit Comments” that is usually the only task required. Something happened within the last week and now when right clicking and choosing “Edit Comments” it is unresponsive to the request, unless now choosing “Show/Hide Comment” first … then going back to choose “Edit Comments”. Why is this extra step now required, when usually it is not required and what changes needs to be made to so that “Show/Hide Comment” is no longer necessary like usual?
Solutions to the Problem Edit Comment in Excel 2007
This sounds odd. The usual culprit is a protected worksheet but in this case the menu option to edit comments doesn't appear so it suggests it's not that.
Can you enter new comments? Can you edit these comments in the normal way of right click and edit comment?
Yes new comments can be added by clicking on "Insert Comment" and yes the new comments can be edited in the normal way.
How can the the old comments be edited in the normal way again?
I have heard of this problem before but never seen it.
As a sensible precaution make a backup of you workbook.
Ensure the problem worksheet is the active (visible) sheet and try this VB code.
ALT+F11 to open vb editor. Right click 'ThisWorkbook' and insert module and paste the code below in on the right.
While still in VB editor, tap the F5 key to run the code, it should run very quickly so don't be surprised if nothing seems to have happened. Go back to the worksheet and test your comments.
Sub RepairComments() Dim CmntRange As Range Dim C As Range Dim Cmnt As String On Error Resume Next Set CmntRange = ActiveSheet.Cells.SpecialCells(xlCellTypeComments) If CmntRange Is Nothing Then MsgBox "no comments on sheet" Exit Sub End If For Each C In CmntRange Cmnt = C.Comment.Text C.Comment.Delete C.AddComment C.Comment.Text Text:=Cmnt Next End Sub
Check if there are memory problems
Memory management issues can also cause a BSOD in Windows 7. Thankfully, Windows 7 has a Memory Management Diagnostic tool that detects and solves problems related to system memory.
Click on the Start button on the Taskbar.
Type "Windows Memory Diagnostic Tool" or "Memory" (without quotes) in the Search box or,
Click on Windows Memory Diagnostic Tool (in the search results).
Click on "Restart now and check for problems (Recommended)".
The system will restart, and you need to follow the instructions given on the screen.
Recommended Method to Repair the Problem: Edit Comment in Excel 2007:
How to Fix Edit Comment in Excel 2007 with SmartPCFixer?
1. Download SmartPCFixer. Install it on your system.
2. After the scan is finished, you can see the errors and problems which need to be repaired.
3. When the Fixing part is done, your computer has been speeded up and the errors have been fixed