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 ?

"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
wrote:

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 ?

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

"Chip Pearson" wrote:

"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
wrote:

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 ?

ALT-BACKARROW
--
Gary''s Student - gsnu200820

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.

"Hyperlinking Back" wrote:

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

"Chip Pearson" wrote:

"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
wrote:

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 ?

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.

"Gary''s Student" wrote:

ALT-BACKARROW
--
Gary''s Student - gsnu200820

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


--
Gary''s Student - gsnu200820


"Hyperlinking Back" wrote:

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.

"Gary''s Student" wrote:

ALT-BACKARROW
--
Gary''s Student - gsnu200820

Thanks Man !!

"Gary''s Student" wrote:

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


--
Gary''s Student - gsnu200820


"Hyperlinking Back" wrote:

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.

"Gary''s Student" wrote:

ALT-BACKARROW
--
Gary''s Student - gsnu200820

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
Shouldn't I put something else like in the parens?

This is fun!

CAM


"Gary''s Student" wrote:

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


--
Gary''s Student - gsnu200820


"Hyperlinking Back" wrote:

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.

"Gary''s Student" wrote:

ALT-BACKARROW
--
Gary''s Student - gsnu200820

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

"CAM" wrote in message
...
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
Shouldn't I put something else like in the parens?

This is fun!

CAM


"Gary''s Student" wrote:

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


--
Gary''s Student - gsnu200820


"Hyperlinking Back" wrote:

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.

"Gary''s Student" wrote:

ALT-BACKARROW
--
Gary''s Student - gsnu200820