Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Go back to previous page
If by page you mean tab or worksheet, then in a standard module enter:
Public neew As Range Public old As Range Sub goback() old.Parent.Activate End Sub Sub init() Set neew = Selection End Sub and in each worksheet enter: Private Sub Worksheet_Activate() Set old = neew Set neew = Selection End Sub First run init(), then move from tab to tab all you like. Run goback() to get back to the previous tab. -- Gary's Student "jweasl" wrote: I need a macro that will take me back to the page I was previously on. I have about 30 pages total, and you often move from one to the next in no particular order. Many times I will run macros on the page before needing to go back as well. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Go back to the previous excel file | Excel Discussion (Misc queries) | |||
go back/previous cell | Excel Programming | |||
Revert back to previous file version | Excel Discussion (Misc queries) | |||
Go back to previous worksheet | New Users to Excel | |||
Roll back to previous date | Excel Worksheet Functions |