Solved

Hyperlink in a worksheet

Posted on 2013-11-13
3
177 Views
Last Modified: 2013-11-13
Folks,
I've noticed on Microsoft's web site numerous uses of a hyperlink to display additional information about a topic without leaving the site.
I would like to incorpoarte the same concept in a worksheet. Since I will have more than one issue I'm going to break this project into several follow-up questions.
First objective:
In the attached worksheet you will see various topics listed from A2:A5. These are my hypelinked cells. On the right side of the worksheet from cells J2:O14 is an example of the data I would like to show when the user selects, for example, the first topic in cell A2 that would appear directly underneath the hyperlink.
Book1.xlsm
0
Comment
Question by:Frank Freese
  • 2
3 Comments
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
ID: 39645872
I'm not sure how to use hyperlink, but you can try groupping and double click event.
Try this sample (macro should be enabled).
With double clich on row you can expand content.
Some details about groups you can find here:'
http://office.microsoft.com/en-us/excel-help/outline-group-data-in-a-worksheet-HA010095247.aspx#BMcreate_an_outline_of_rows
Book1.xlsm
0
 

Author Comment

by:Frank Freese
ID: 39645948
Als315,
Interesting - - let me study this more please.
0
 

Author Closing Comment

by:Frank Freese
ID: 39646667
Thanks....I'm going to continue look for alternatives. I have no problem with what you presented and am grateful for your help.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question