Results 1 to 2 of 2

Map with Links?

This is a discussion on Map with Links? within the Excel Questions forums, part of the Question Forums category; We have offices through out the U.S. What I would like to do is to have a spreadsheet with a ...

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752

    Default Map with Links?

    We have offices through out the U.S. What I would like to do is to have a spreadsheet with a map of the U.S. and a little icon where we have an office located and when someone clicks on an office, they get taken to the spreadsheet that has data for that office.

    Any suggestions?

    Thanks

  2. #2
    MrExcel MVP
    Int'l Moderator
    Greg Truby's Avatar
    Join Date
    Jun 2002
    Location
    39° 17' 15" N, -94° 40' 26" W
    Posts
    9,708

    Default Re: Map with Links?

    Not sure of the specific properties of your "map". I have XL2002 and MS took away the Insert | Map function. What you can do is insert a shape, select that shape and then Insert | Hyperlink... So theoritically put a clear circle or polygon over your office location and you should have a means of doing this. (I've no idea if XL2000 or earlier has Insert | Hyperlink... though.)

    HTH
    Greg
    ………………………………………………
    Work: XL 2003, 2007 and 2010 on Windows 7
    Please use CODE tags - especially for longer excerpts of code.

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
  •  


DMCA.com