Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Location
    Cape Cod, Massachusetts, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Comment Indicator (2003)

    I want the comment in a worksheet to display when the user hovers their cursor over a cell containing a comment, but I do not want the comment indicator (corner red triangle) to be visible. Is there a way to create this no-indicator condition?

    Paul

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

    Re: Comment Indicator (2003)

    No, you can only choose between the options in the View tab of Tools | Options:
    - No indicator, no comment.
    - Indicator but no comment.
    - Indicator and comment.
    Moreover, this is a user-level setting, not a workbook or worksheet-level setting. In other words, the setting you apply doesn't affect other users opening the workbook.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2006
    Location
    Cape Cod, Massachusetts, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comment Indicator (2003)

    Hans,

    Thanks for the quick reply.

    Can I instead change the color of the indicator to make it the same as the background color effectively making it go away (for all users) ?

    Paul

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

    Re: Comment Indicator (2003)

    No, the red color is hard-coded. You could use the Drawing toolbar to put a small triangle with transparent border and white fill over each comment indicator, but that is very tedious, and users could easily move the triangles unless the sheet is protected.

    Perhaps you can use Validation instead of comments:
    - Select Data | Validation...
    - The Allow dropdown in the first tab should read "All Values" - leave it that way.
    - Activate the Input Message tab.
    - Specify a suitable title and message.
    - Click OK.
    This message will *not* appear when the user hovers the mouse pointer over the cell, it will only be shown when the user selects the cell.

  5. #5
    4 Star Lounger
    Join Date
    Feb 2006
    Location
    Cape Cod, Massachusetts, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comment Indicator (2003)

    Yes, the data validation is a good alternative I looked at. The characteristic that solution has that I do not like is that the message box appears to not have the size controls the comment box does and I would like to have wide text boxes.

    The sheet will be protected, maybe I will look at drawing the triangles.

    Thanks,
    Paul

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

    Re: Comment Indicator (2003)

    If the sheet is protected and if you have a limited number of comments, drawing triangles is viable (you can draw one, then copy and paste). But if you have many comments, it's not much fun...

  7. #7
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comment Indicator (2003)

    Hi Paul

    Is this of any use to you

    Sub RemoveIndicatorShapes()

    Dim ws As Worksheet
    Dim shp As Shape

    Set ws = ActiveSheet

    For Each shp In ws.Shapes
    If Not shp.TopLeftCell.Comment Is Nothing Then
    If shp.AutoShapeType = _
    msoShapeRightTriangle Then
    shp.Delete
    End If
    End If
    Next shp

    End Sub

    I have not used it so I do not know if it works, if it does and you wish to thank the author the code is from the http://www.contextures.com website, thanks to Debra Dalgleish

    Cheers

    Steve

    Editted to change typo in authors name
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  8. #8
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Comment Indicator (2003)

    Hi Steve,

    The code you posted does not remove the "actual" comment indicator, but a little autoshape that is added by another macro. Once that macro is run (adding a little autoshape over the indicator to print cells with comments), the macro you posted for Paul then removes the little autodhape again, not the actual comment indicator. See http://www.contextures.com/xlcomments03.html#Indicator

    BTW: Nice find, and the www.contextures.com site is a great site for code snippets.
    Regards,
    Rudi

Posting Permissions

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