ExcelBanter - hyperlink: back to last worksheet

This could be done using VBA if you're familiar with that. Here is one
way.

First, create a sheet named "Data". This sheet can be hidden if you'd like.
Next, press Alt+F11 to bring up the VB editor.
Double-click on "ThisWorkbook".
Paste the following code:

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
Sheets("Data").Range("A2").Value = Sheets("Data").Range("A1").Value
Sheets("Data").Range("A1").Value = ActiveSheet.Name
End Sub

Next, right-click "ThisWorkbook" again and goto "Insert" and then select
"Module".
Paste the following code:

Sub ActivateLastSheet()
Sheets(Sheets("Data").Range("A2").Value).Activate
End Sub

Close the VB Editor window.
From your Excel window, click Tools-Macro-Macros.
Select ActivateLastSheet and then click Options.
In this section you can assign a short-cut key to easily access the code
that activates the previous sheet you were on.

Hope this is helpful.
Paul

The only way I know of doing it, though, would be to put a bit of code in
each sheet. In my example, you'd also need a sheet in which the code saves
the current sheet's name prior to changing to another.

"my" wrote in message
...
Hi,

I'm trying to create a hyperlink like the Back button you'd have in an
internet browser. So which ever worksheet I'm in, I want to be able to
click
on a link that takes me back to the last worksheet I was on. Is this
possible?

Thanks in advance! :)