Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hyperlink: back to last worksheet
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! :) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I 'hyperlink' within a workbook from the first worksheet? | Excel Worksheet Functions | |||
How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
hyperlink to another worksheet | Excel Worksheet Functions | |||
worksheet columns changed from letter to number, how change back | New Users to Excel | |||
How do I get a hyperlink to track specific data in a worksheet? | Excel Discussion (Misc queries) |