人気ブログランキング | 話題のタグを見る

Troubleshoot:Edit Comment in Excel 2007 Error

Edit Comment in Excel 2007

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

Download SmartPCFixer to Fix It (Free)

Hi,
 
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?

Hi,
 
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.

  1. Click on the Start button on the Taskbar.
  2. Type "Windows Memory Diagnostic Tool" or "Memory" (without quotes) in the Search box or,
  3. Click on Windows Memory Diagnostic Tool (in the search results).
  4. Click on "Restart now and check for problems (Recommended)".
  5. 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


Related: Cant Get Password To Network So Can Hook Up Ipod,Changing The Home Page Back To The Original Setting-- How Do I Do This?,Changing The Names Of Sheet Names In Excel 2007 Workbook,Change Internet Explore Settings - I Need To Switch Back To Internet Explorer 8 From 9 Beta,Chart: Display All Of Each X Axis Value. Join All Points With A Line.,Computer Turning Off Every 10 - 15 Mins With A Blue Screen.,Computer Names In My Network Places Are Old,Computer Goes Into Sleep Mode It Seems To Crash,Configuration File Missing Error For A Program Installed.,Computer Freeze, With Event 7009,Customizing Address Bar In IE 8,D DRIVE/DVD DRIVE WON'T WORK,Custom Created Wallpaper In Vista Loses Resolution In Windows 7,Default App Bug In Windows 8.1,Default Gateway Keeps Dropping,Save Costs By Opting For Used Cars,St. Martin Real Estate Laws,Basic Private Label Content Tactics,Save On Used Office Furniture And Used Cubicles,Jumping Rope Can Jumpstart Your Health!
Read More: Display game tables Tech Support,Fast Solution to Error: dopo un backup su disco esterno, all'avvio di windows il sistema non riparte.,Fast Solution to Error: displace data in specify range,Tech Support: Does Microsoft Office Live support java script?,How to Fix Problem - Downloading Internet Explorer 8 - does that mess up the existing computer settings?,Desktop icons changed,Deskstop performance for widows aero is just 3.4,Does Office 2010 support Office 2007 Excel files?,Does Win7 Pro 64Bit support creating a System Image from 2 SSD Drives that are in Raid 0?,Drive e and f wont work!!!
by roxioisscriptms | 2016-09-30 09:49