craigewens
asked on
Returning to 'calling' hyperlink cell from another hyperlink.
I'm sure this is quite easy to explain, but as usual I’ll drag it out a bit :) sorry.
In sheet1 of excel I have hyperlinks to sheet2. In sheet 2 I have one hyperlink "BACK".
How do I make the BACK hyperlink go to the cell in sheet1 that just called it? The problem is that the cells in sheet1 that contain the hyperlinks to sheet2 are likely to move about so no 'hard coding' of cell references is possible.
I have tried to think of a way top make VB do this but failed so I turned to the Microsoft Script Editor, but that's written in Java (at a guess) and I’m even worse with that than I am with VB.
Can anyone make a suggestion of how to do this or if I’ve made myself unclear please post a comment or two asking me questions.
Thanks ppl.
In sheet1 of excel I have hyperlinks to sheet2. In sheet 2 I have one hyperlink "BACK".
How do I make the BACK hyperlink go to the cell in sheet1 that just called it? The problem is that the cells in sheet1 that contain the hyperlinks to sheet2 are likely to move about so no 'hard coding' of cell references is possible.
I have tried to think of a way top make VB do this but failed so I turned to the Microsoft Script Editor, but that's written in Java (at a guess) and I’m even worse with that than I am with VB.
Can anyone make a suggestion of how to do this or if I’ve made myself unclear please post a comment or two asking me questions.
Thanks ppl.
ASKER
Thanks for your comment Richie and i understand what your saying (partially) but all the hyperlinks are created through excel rather than VB, this means (as far as i can figure out) that VB has no knowledge of them.
If you have the time, could you add a little more to your previous comment because atm the vb sheet is blank... :(
Thanks
Craig.
If you have the time, could you add a little more to your previous comment because atm the vb sheet is blank... :(
Thanks
Craig.
ASKER
Richie, i've played about even more with what you suggested but all the stuff i create in VB through excel requires to be 'run' (macro).
Can you think of a way to do this still?
If your unsure open up excel and try what i am trying to do (takes about 10 seconds), you'll soon see where i'm having the troubles.
Thanks.
Can you think of a way to do this still?
If your unsure open up excel and try what i am trying to do (takes about 10 seconds), you'll soon see where i'm having the troubles.
Thanks.
For reason thta is unknown, i did not receive your first comment notif.
Let me see....
Let me see....
Just a question: why did you use a hyperlink to get this work?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks ever so much for replying so quickly, once EE started sending out the notifications again :)
But i found this on another question:
Sub BackToWhenceYouCame()
On Error GoTo skip
CommandBars("Web").Control s("Back"). Execute
skip:
End Sub
It seems to do what i'm after and works from calling this sub from any command button click.
Can you think of any reasons or situations why i shouldn't use this? (version dependant, OS dependant etc etc)
Of course you can still have the points anyway as almost every question i ask or search for you seem to have given the accepted answer :)
Thanks.
But i found this on another question:
Sub BackToWhenceYouCame()
On Error GoTo skip
CommandBars("Web").Control
skip:
End Sub
It seems to do what i'm after and works from calling this sub from any command button click.
Can you think of any reasons or situations why i shouldn't use this? (version dependant, OS dependant etc etc)
Of course you can still have the points anyway as almost every question i ask or search for you seem to have given the accepted answer :)
Thanks.
I don't know if it would works on office97.
Dont care about points, i like points ONLY if i deserve them.
Cheers
Dont care about points, i like points ONLY if i deserve them.
Cheers
ASKER
Well i tested your code and it is just as effective as the other suggestion i found. Seeing as you have your doubts on if it'll work in other versions of office i guess you ONLY deserve the points after all :)
Thx
Thx
Well, thanks for "A" grade!
dim rngHyp as range
When you do click on hyperlink 1, set that variable to cell with hyperlink.
On sheet 2, call hyperlink "back" and do something like:
rngHyp.select
Hope it helps