Choosing window to follow hyperlinks within workbook
Hello, this seems like it should be easy, but I have been unable to
find a solution...
I have a workbook containing many sheets. Normal operation is to have
two windows open in the workbook w9ith each displaying a different
sheet (assume arranged horizontally).
Located through any given sheet are hyperlinks to other cells on the
same sheet or different sheets. When I click on the hyperlink, I would
like it to follow it and display it in the other already open window.
Right now, it always follows the hyperlink in Window 1 regardless of
which window you are working in.
I've tried using the hyperlink events and dictating which window to
follow in, but I have been unsuccessful.
any thoughts?
Thanks...
Klasen
|