Results 1 to 10 of 10
  1. #1
    Star Lounger
    Join Date
    May 2003
    Posts
    69
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Editing Comments (any)

    I have a spreadsheet with many comments thoughout, and suddenly I cannot edit some of the comments. Only a few, the other I can edit. What would cause these few to not allow me to edit them? When I right-click on the cell and select edit comment, nothing happens. Please help... Thanks.

    -tmg9671

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Editing Comments (any)

    Could you attach a small workbook that demonstrates the problem?

  3. #3
    Star Lounger
    Join Date
    May 2003
    Posts
    69
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Editing Comments (any)

    See attached. Comment 1 can be edited, but Comment 2 cannot. Thanks.

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Editing Comments (any)

    That's weird! I can edit comment 2 by selecting its cell, choosing Show comment, moving the cursor off the cell and then back over it.
    Did you create them in different ways?
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    Star Lounger
    Join Date
    May 2003
    Posts
    69
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Editing Comments (any)

    That is weird. I tried that too and it worked. I didn't create them any differently, other than perhaps copying and pasting the comment into a different cell.

    At least I can still edit them. Thanks for your help.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Editing Comments (any)

    This is strange - I cannot explain why it happens. The problem is mentioned in the Micorosft newsgroups, but without a clear solution.

    If you set the display option for comments to 'Comment and indicator', it is also possible to select the cell, then click in the comment to edit it.

  7. #7
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Cincinnati, Ohio, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Editing Comments (any)

    When I select "show comment" from the context menu, I am able to edit Comment 2...as opposed to selecting Edit Comment from the context menu...

    Odd problem.

  8. #8
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Editing Comments (any)

    Try running this macro - it will basically delete and replace all your comments with "fresh ones" which seemed to help on your sample workbook:
    <pre>Sub CleanComments()
    Dim cmt As Comment
    Dim strComment As String
    Dim rngCell As Range
    Dim sglHeight As Single, sglWidth As Single
    For Each cmt In ActiveSheet.Comments
    With cmt
    sglHeight = .Shape.Height
    sglWidth = .Shape.Width
    Set rngCell = .Parent
    strComment = .Text
    .Delete
    End With
    With rngCell
    .AddComment strComment
    With .Comment.Shape
    .Height = sglHeight
    .Width = sglWidth
    .TextFrame.Characters.Font.Bold = True
    End With
    .Comment.Visible = False
    End With
    Next cmt
    End Sub
    </pre>


    HTH
    Regards,
    Rory

    Microsoft MVP - Excel

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Editing Comments (any)

    Yes, that is what Rory mentioned in his reply. It's definitely a weird problem - I cannot find any relevant difference in the properties of the two cells and their comments that would explain why Edit Comment works for one, but not for the other. <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>

  10. #10
    Star Lounger
    Join Date
    May 2003
    Posts
    69
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Editing Comments (any)

    Well, at least there is a way to edit them. Thank you all for your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •