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

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

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 ?