Results 1 to 3 of 3

Thread: Hide/Show Comment Shapes on Worksheet

  1. #1
    Acolyte Tech's Avatar
    Join Date
    Jan 2017
    Posts
    23
    Articles
    0
    Excel Version
    2010

    Hide/Show Comment Shapes on Worksheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I have this code to hide or show comment shapes on the Transactions sheet. Do the shapes have to somehow be assigned to the 'HelpPopUpsGroup' ?

    Thanks for any help

    Code:
    Sub ShowHelpTransactionsScrn()
    If Sheet5.Range("C2").Value = "Show Help" Then
    Sheet5.Shapes("HelpPopUpsGrp").Visible = True
    Sheet5.Range("C2").Value = "Hide Help"
    Else:
    Sheet5.Shapes("HelpPopUpsGrp").Visible = False
    Sheet5.Range("C2").Value = "Show Help"
    End If
    End Sub

  2. #2
    Acolyte Tech's Avatar
    Join Date
    Jan 2017
    Posts
    23
    Articles
    0
    Excel Version
    2010
    I received a solution from another forum here:

    https://chandoo.org/forum/threads/hi...h-macro.42532/

    Thank you

  3. #3
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,270
    Articles
    0
    Excel Version
    Office 365 Subscription
    Thanks for telling us, but if you cross-post, you are required to declare it immediately. This rule exists here, on Chandoo and on pretty much all forums.
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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