New address for a Shape hyperlinks for excel RRS feed

All replies

  • Hi,

    Based on your description, you want to get the result via VBA code, I'll move your question to the MSDN forum for Excel

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    Emi Zhang
    TechNet Community Support

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    If you have feedback for TechNet Subscriber Support, contact

    Thursday, October 20, 2016 6:20 AM
  • Hi Maryselhorst,

    from the description the thread it looks like you want to set a Hyperlink of a shape.

    use the code mentioned below.

    Sub SetHyperlinkOnShape()
        Dim ws As Worksheet
        Set ws = ThisWorkbook.Sheets("Sheet1")
        Dim hyperLinkedShape As Shape
        Set hyperLinkedShape = ws.Shapes("Rectangle 1")
        ws.Hyperlinks.Add Anchor:=hyperLinkedShape, Address:="", _
            SubAddress:="Sheet2!A1:A1", ScreenTip:="Demo Link"
    End Sub


    Shape.Hyperlink Property (Excel)



    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

    Friday, October 21, 2016 6:53 AM