Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: comment & indicator

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Midwest, USA
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello! I know you can change the comments from showing or not showing by going through options. Is there anyway to limit that function just on certain sheets... not just the entire workbook? Thanks in advance...!

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can use the WorkSheet Activate Event to control the display.

    In the module for each sheet you want to hide comments enter this code.

    Private Sub Worksheet_Activate()

    Application.DisplayCommentIndicator=0

    End Sub

    Enter the same on sheets where you want to see the comments, changing the 0 to a 1

    [ This Message was edited by: lenze on 2002-03-07 11:03 ]

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Midwest, USA
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you!

Some videos you may like

User Tag List

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
  •