+ Reply to Thread
Results 1 to 5 of 5

Hyperlink Visio icon to specific page in Excel Workbook

  1. #1
    Registered User
    Join Date
    01-18-2021
    Location
    Madison, WI
    MS-Off Ver
    Office 365 Version 2012 Build 13530.20376
    Posts
    3

    Question Hyperlink Visio icon to specific page in Excel Workbook

    Good morning, all!

    I'm building a spreadsheet that I'd like to link specific icons in a Visio drawing to specific pages in the Excel workbook. Tried adding a name to a cell and linking to that; don't have Insert | Name available. Tried making hyperlink in Visio to the tab name, both with and without a cell reference in that named tab. All I get is "Reference isn't valid." I'm beginning to think the hyperlink simply won't work. I can hyperlink from one page to another wtihin the spreadsheet and can link to a text file from the spreadsheet to the .txt. The Visio hyperlink opens the spreadsheet, but I can't link to any specific page in the workbook.

    Any thoughts on what I'm missing?

    thanks!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,436

    Re: Hyperlink Visio icon to specific page in Excel Workbook

    See this recent thread: https://www.excelforum.com/excel-gen...rom-visio.html
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    01-18-2021
    Location
    Madison, WI
    MS-Off Ver
    Office 365 Version 2012 Build 13530.20376
    Posts
    3

    Re: Hyperlink Visio icon to specific page in Excel Workbook

    Thanks ! I was able to use that and find the place where Excel moved "Define Name..." to - it's under Formulas now.

    I can make names and anchor them to cells in the worksheet I want, and make Visio hyperlink to them. I'll be keeping all the worksheets, txt files and the Visio drawing in the same folder, so the relative addresses shouldn't change.

    Thanks for the pointer!

  4. #4
    Registered User
    Join Date
    01-18-2021
    Location
    Madison, WI
    MS-Off Ver
    Office 365 Version 2012 Build 13530.20376
    Posts
    3

    Thumbs up Re: Hyperlink Visio icon to specific page in Excel Workbook

    Thanks ! I was able to use that and find the place where Excel moved "Define Name..." to - it's under Formulas now.

    I can make names and anchor them to cells in the worksheet I want, and make Visio hyperlink to them. I'll be keeping all the worksheets, txt files and the Visio drawing in the same folder, so the relative addresses shouldn't change.

    Thanks for the pointer!

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,436

    Re: Hyperlink Visio icon to specific page in Excel Workbook

    You're welcome.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 01-13-2021, 06:29 PM
  2. Can a hyperlink from excel image be able to open Publisher to a specific page?
    By JJFletcher in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2017, 10:14 PM
  3. Replies: 1
    Last Post: 04-03-2014, 05:24 AM
  4. Replies: 0
    Last Post: 10-07-2013, 10:24 AM
  5. Replies: 3
    Last Post: 01-31-2013, 03:48 AM
  6. [SOLVED] Excel should let hyperlink of PDF jump to a specific page like IE.
    By Kenn Tan in forum Excel General
    Replies: 4
    Last Post: 01-25-2013, 08:40 AM
  7. External hyperlink to a specific page in a workbook
    By Nimbus55 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2006, 08:13 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1