Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving to Previous Worksheet
Is there a quick way to open the last worksheet you had open prior to the one
you are currently viewing, and toggle between the two sheets? I am looking for something like the alt+tab command for windows. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving to Previous Worksheet
I'm assuming you do mean Worksheet, as stated, and not Workbook.
Anyway, you can use some code to do this. I've previously done something like this with the following: 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 "Zootie" wrote in message ... Is there a quick way to open the last worksheet you had open prior to the one you are currently viewing, and toggle between the two sheets? I am looking for something like the alt+tab command for windows. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
continue page numbers from previous worksheet | Excel Discussion (Misc queries) | |||
Moving data from from one worksheet to another | Excel Worksheet Functions | |||
Moving Objects in a Worksheet | Excel Discussion (Misc queries) | |||
How to stop the cursor moving the whole excel worksheet | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) |