Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Posts
    67
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hyperlink to A Chart Page (2000)

    I want to use a hyperlink to jump to a Chart page in a workbook, but i cant seem to get any referebce to the page , is this possible ?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink to A Chart Page (2000)

    You can only create hyperlinks to cells.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Hyperlink to A Chart Page (2000)

    A workaround is to add a description to a cell. Format it to LOOK like a hyperlink, (blue / underline)

    Create the macro Change the chart sheet name as appropriate
    <pre>Sub GotoChart1()
    Sheets("Chart1").Select
    End Sub
    </pre>


    Add a LABEL from the FORMS toolbar to the cell you want to link to the chart
    right-click and Edit the text and remove it all so it is blank.
    right click on the label and assign macro to the macro created.

    Even though the label is not visible, it will still have a finger icon so will LOOK and act like a link (except the back arrow will not work). You will have to create a macro wif you want a button to return to the other sheet.

    Steve

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

    Re: Hyperlink to A Chart Page (2000)

    <img src=/S/sneaky.gif border=0 alt=sneaky width=15 height=15> !

Posting Permissions

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