I'm working my challenge out with lots of help from this great forum but am stumped at a point.
My objective is to click on a hyperlink which will use that cell text as reference to a worksheet name in a second target workbook in the same directory and take the user there leaving the source worksheet open.
My current solution:
has big drawbacks.
First, the link created records the path which then is invalid when the 2 files are moved around (which they must be able to do). If it could somehow just state "go to this sheet in this file, in the same directory I am in" at runtime that would be ideal.
Second, the source sheet closes, requiring use of he web toolbar "back" button to return.
I'd be grateful for any pointers in the right direction on these issues. Thanks!
Working in Excel v11.1 Mac - for use on all recent version/platforms
My objective is to click on a hyperlink which will use that cell text as reference to a worksheet name in a second target workbook in the same directory and take the user there leaving the source worksheet open.
My current solution:
Code:
ActiveCell.Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address ="ScriptDetail_One.xls", _
SubAddress:=ActiveCell & "!A3"First, the link created records the path which then is invalid when the 2 files are moved around (which they must be able to do). If it could somehow just state "go to this sheet in this file, in the same directory I am in" at runtime that would be ideal.
Second, the source sheet closes, requiring use of he web toolbar "back" button to return.
I'd be grateful for any pointers in the right direction on these issues. Thanks!
Working in Excel v11.1 Mac - for use on all recent version/platforms
