A cell to link a worksheet using VBA in EXCEL RRS feed

  • Question

  • Hello 

    I am new to excel and VBA. I am trying to create something like a hyperlink

    I have a workbook with 'Test 1' worksheet and the following text in A1 and A2 - First Sheet and Second Sheet respectively

    I have another workbook with two worksheets named 'FirstSheet' and 'SecondSheet'. What I am trying to achieve is when I click on the text in Workbook1.Test1.A1 - it should open the Workbook2.FirstSheet worksheet.

    Any help will be useful   

    Friday, June 3, 2016 10:55 AM


All replies