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.
|