+ Reply to Thread
Results 1 to 4 of 4

Image that links to a different worksheet within same file

  1. #1
    Registered User
    Join Date
    08-19-2009
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    18

    Image that links to a different worksheet within same file

    I've inserted an image (a 'camera' shot of a different worksheet) into the main dashboard (first worksheet) of my file.

    I want to ensure that when the user clicks on the image, they are taken straight to the appropriate worksheet. I assumed this would be simple a via an edited hyperlink, however I cannot figure out how it is done... it does not appear as simple as I had thought it would be!

    Any ideas?

  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
    37,297

    Re: Image that links to a different worksheet within same file

    Insert the image
    Right click on the image
    Select Hperlink...
    In the left hand pane, select "Place in this document"
    Select a cell reference and
    Select a worksheet
    Click OK
    Click off the picture to deselect it
    Hover over the picture and click on it

    Done

    Regards

  3. #3
    Registered User
    Join Date
    08-19-2009
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    18

    Re: Image that links to a different worksheet within same file

    Excellent - worked a charm.

    Many thanks!

  4. #4
    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
    37,297

    Re: Image that links to a different worksheet within same file

    You're welcome. Thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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