Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Jump between sheets
Is it possible in a multi-sheet workbook to create a procedure to jump
back to the sheet and the place you were in previously, ie without using the tabs to move about. If you were in sheet 6 for example and moved by a macro to Sheet 20, is there a way to identify that you have just been in sheet 6 and use a macro to be linked to a command button for example to jump back to it. Hope this is well enough explained and I would be grateful for any guidance. Kind regards Graham Haughs Turriff, Scotland |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Jump between sheets
This is the way I do it:-
' Switch to/from summary sheet ' If ActiveSheet.Name = "Summary" Then oldsheet = Worksheets("Summary").Range("Z1").Value Sheets(oldsheet).Select Else oldsheet = ActiveSheet.Name Sheets("Summary").Select Worksheets("Summary").Range("Z1").Value = oldsheet End If "Graham Haughs" wrote: Is it possible in a multi-sheet workbook to create a procedure to jump back to the sheet and the place you were in previously, ie without using the tabs to move about. If you were in sheet 6 for example and moved by a macro to Sheet 20, is there a way to identify that you have just been in sheet 6 and use a macro to be linked to a command button for example to jump back to it. Hope this is well enough explained and I would be grateful for any guidance. Kind regards Graham Haughs Turriff, Scotland |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Jump between sheets
Maybe you could use Jan Karel Pieterse's utility:
http://www.jkp-ads.com/Download.htm Look for GoBack.Zip Graham Haughs wrote: Is it possible in a multi-sheet workbook to create a procedure to jump back to the sheet and the place you were in previously, ie without using the tabs to move about. If you were in sheet 6 for example and moved by a macro to Sheet 20, is there a way to identify that you have just been in sheet 6 and use a macro to be linked to a command button for example to jump back to it. Hope this is well enough explained and I would be grateful for any guidance. Kind regards Graham Haughs Turriff, Scotland -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Key to Jump to end of row | Excel Discussion (Misc queries) | |||
Worksheet Jump | Excel Worksheet Functions | |||
How do I jump between sheets in Excel using keyboard? | Excel Discussion (Misc queries) | |||
Discreet jump | Charts and Charting in Excel | |||
How to jump between TextBoxes | Excel Programming |