Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Hyperlinked "Map" to Complex Model
Workbook A is a multisheet complex model.
Workbook B is a "Site Map" -- to the contents of Workbook A. Each workbook is open in a separate instance of Excel (I have two Excel applications running). This is because I have two computer screens. This is the only way I've figured out to get separate workbooks on different screens. By clicking on a cell on the Site Map (Worksheet B), I want to be taken to a specific cell on Worksheet A. First of all, is this generally the way you would go about this? I'm asking because maybe all I want is a floating toolbar with hyperlink capabilities -- but it would have to be a fairly large toolbar that could be maximized/minimized at will. Any suggestions? Hyperlinks don't work with the method I tried. Thanks for your help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Hyperlinked "Map" to Complex Model
Running separate instances of excel means losing many of the benefits of
using excel. Hyperlinks will work if you do the the following: -open both workbooks in one instance of excel -strecth your excel window to cover both screens - goto Window Arrange and select tile vertically This will allow for the hyperlinks to work. I've got two screens and this is the way that I work with them. -- JNW "SteveC" wrote: Workbook A is a multisheet complex model. Workbook B is a "Site Map" -- to the contents of Workbook A. Each workbook is open in a separate instance of Excel (I have two Excel applications running). This is because I have two computer screens. This is the only way I've figured out to get separate workbooks on different screens. By clicking on a cell on the Site Map (Worksheet B), I want to be taken to a specific cell on Worksheet A. First of all, is this generally the way you would go about this? I'm asking because maybe all I want is a floating toolbar with hyperlink capabilities -- but it would have to be a fairly large toolbar that could be maximized/minimized at will. Any suggestions? Hyperlinks don't work with the method I tried. Thanks for your help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Hyperlinked "Map" to Complex Model
aha!
thank you. "JNW" wrote: Running separate instances of excel means losing many of the benefits of using excel. Hyperlinks will work if you do the the following: -open both workbooks in one instance of excel -strecth your excel window to cover both screens - goto Window Arrange and select tile vertically This will allow for the hyperlinks to work. I've got two screens and this is the way that I work with them. -- JNW "SteveC" wrote: Workbook A is a multisheet complex model. Workbook B is a "Site Map" -- to the contents of Workbook A. Each workbook is open in a separate instance of Excel (I have two Excel applications running). This is because I have two computer screens. This is the only way I've figured out to get separate workbooks on different screens. By clicking on a cell on the Site Map (Worksheet B), I want to be taken to a specific cell on Worksheet A. First of all, is this generally the way you would go about this? I'm asking because maybe all I want is a floating toolbar with hyperlink capabilities -- but it would have to be a fairly large toolbar that could be maximized/minimized at will. Any suggestions? Hyperlinks don't work with the method I tried. Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a "date selector box" or "pull down box" in a cell | Excel Worksheet Functions | |||
Creating an "If" Function with multiple "if"s | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
"Excel.Application" Object Model | Excel Programming |