Hyperlink

  • Hy,


    could you help me to find the correct code to open a hyperlink - I´ve got 2 sheets in excel, one with a command button and another with a hyperlink and I want to open the hyperlink in the second sheet when I click the command button...


    The code I use is following:


    Code
    sheets("SAP2").select
    range("A1").select
        Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True


    What went wrong with the code because it doesn´t run??


    :thanx: for help


    Balu

  • Re: Hyperlink


    Balu


    A similar code works perfect on my computer. Remember to format A1 on sheet SAP2 to be a hyperlink.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!