View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stevec stevec is offline
external usenet poster
 
Posts: 177
Default 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.