Hyperlink Back

H

Hyperlinking Back

I need to create a hyperlink that navigates back, not to a specific
sheet/cell. Is there a simple way to format the HYPERLINK command to do this ?
 
C

Chip Pearson

"Back" to what? The previously selected cell? Worksheet? I don't think
it can be done with the HYPERLINK worksheet function, but it can
probably be done with a Hyperlink object attached to a cell.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Wed, 17 Dec 2008 07:40:16 -0800, Hyperlinking Back <Hyperlinking
 
H

Hyperlinking Back

Back to where you were before you got to where you are. I want the same
behavior as is the Web toolbar category Back command (green circle with left
arrow), also the same behavior as the Back button on your web browser,
explorer...etc. Whatever object accomplishes this (Hyperlink command, button,
marco) behavior doesn't matter but the simplest approach would be preferred.

Mike
 
H

Hyperlinking Back

Let me clarify - I want to make it braindamaged simple for a viewer of the
worksheet to navigate back. A button or hyperlink (big bold letters saying
BACK) is what I envision.
 
H

Hyperlinking Back

Yes I know that keyboard short cut but I need to make this braindamaged
simple and obvious for others. So a button or hyperlink is what I envision.
 
G

Gary''s Student

Plop any kind of button, or Picture, or ClipArt on the sheet and assign this
macro to it:

Sub goback()
Application.Goto
End Sub

This is the VBA equivalent to ALT-BACKARROW.

Alternatively, you can programmatically:

View > Toolbars > Web

There is a nice backarrow on this toolbar
 
H

Hyperlinking Back

Thanks Man !!

Gary''s Student said:
Plop any kind of button, or Picture, or ClipArt on the sheet and assign this
macro to it:

Sub goback()
Application.Goto
End Sub

This is the VBA equivalent to ALT-BACKARROW.

Alternatively, you can programmatically:

View > Toolbars > Web

There is a nice backarrow on this toolbar
Click to expand...
 
C

CAM

OK.......I've never created a macro before but........I've started the
process and I have a Module1 (Code) window up that has "(General)" to the top
left and "goBack" in the top right. Beneath is the space where the actual
application run code would be written........Right?!?!?

What do I put here? What you wrote, below?
Sub goback()
Application.Goto
End Sub
Click to expand...
Shouldn't I put something else like in the parens?

This is fun!

CAM
 
P

Patrick Molloy

you have the correct code module
"Application.Goto" reverses a goto if you will, so long as there was one,
otherwise it errors

to test:
so paste the code. select a cell on the sheet. hit F5 and use the goto to go
to another cell, then run the code -- you'll see the original cell is now
selected

Sub goback()
on error resume next
Application.Goto
on error goto 0
End Sub
 
Top