Remove red indicators from notes excel 2016
Results 1 to 9 of 9

Thread: Remove red indicators from notes excel 2016
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Apr 2018
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Remove red indicators from notes excel 2016

    Hi!

    I have a sheet with a lot of comments which show additional information. With al the red right top corner triangles for every comments it gets very messy.

    Is there a way to not show these indicators? I found the 'no comments and indicators' function in Excel but this automatically removes the comment as well.

    Thanks for any help!

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    25,557
    Post Thanks / Like
    Mentioned
    444 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Remove red indicators from notes excel 2016

    Goto > File > Options > Advanced > scroll down to "Display" > select "No comments or indicators"
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    New Member
    Join Date
    Apr 2018
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Remove red indicators from notes excel 2016

    Quote Originally Posted by Fluff View Post
    Goto > File > Options > Advanced > scroll down to "Display" > select "No comments or indicators"
    Hi Fluff,

    This also hides the note itself, I just want to hide the red indicator.

  4. #4
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    25,557
    Post Thanks / Like
    Mentioned
    444 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Remove red indicators from notes excel 2016

    Not sure that's possible.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  5. #5
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,683
    Post Thanks / Like
    Mentioned
    28 Post(s)
    Tagged
    13 Thread(s)

    Default Re: Remove red indicators from notes excel 2016

    There is a script at this site which shows how to hide those Red indicators:
    https://www.contextures.com/xlcomments03.html#Formatted
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

  6. #6
    New Member
    Join Date
    Apr 2018
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Remove red indicators from notes excel 2016

    Quote Originally Posted by My Aswer Is This View Post
    There is a script at this site which shows how to hide those Red indicators:
    https://www.contextures.com/xlcomments03.html#Formatted
    I'll give that a go. You think that's compatible with Excel 2016?

  7. #7
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,683
    Post Thanks / Like
    Mentioned
    28 Post(s)
    Tagged
    13 Thread(s)

    Default Re: Remove red indicators from notes excel 2016

    I really do not know. I do not use 2016
    Quote Originally Posted by Bram1212 View Post
    I'll give that a go. You think that's compatible with Excel 2016?
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

  8. #8
    New Member
    Join Date
    Apr 2018
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Remove red indicators from notes excel 2016

    I found the following code which should do the trick. Does not work for me unfortunately. I'm not really a code guy myself but maybe one of you sees what's missing/wrong?

    Sub RemoveIndicatorShapes()
    'Update 20141110
    Dim pWs As Worksheet
    Dim pShape As Shape
    Set pWs = Application.ActiveSheet
    For Each pShape In pWs.Shapes
    If Not pShape.TopLeftCell.Comment Is Nothing Then
    If pShape.AutoShapeType = msoShapeRightTriangle Then
    pShape.Delete
    End If
    End If
    Next
    End Sub




  9. #9
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    25,557
    Post Thanks / Like
    Mentioned
    444 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Remove red indicators from notes excel 2016

    That code does not remove the comment/note indicator from a cell.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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