Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple VBA question (?)
Hi all, probably quite simple question, but I can't find the answer ...... In my Excel-application 4 pages (worksheets) exist: for example A,B,C and D Button on page A moves the user to page D A similar button on page B navigates user also to page D Now I wish to implement one button on page D "back" it should move the user back to the originating page, i.e. where he began his journey. In some cases he should go back to A, but sometimes to B. How should Excel remember the starting page?? I tried Dim blabla as Name; blabla = Active.Worksheet.Name then navigate to page D, then return to blabla. But the only thing happening is lots of error messages. I presume the solution could be simple? I am very grateful with an answer! Thanks, Kees -- Kees Korver ------------------------------------------------------------------------ Kees Korver's Profile: http://www.excelforum.com/member.php...o&userid=21562 View this thread: http://www.excelforum.com/showthread...hreadid=558249 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple VBA question (?)
Add this code to Thisworkbook (right click the excel icon next to file on the
Menu bar and select view code)... Public wksLast As Worksheet Private Sub Workbook_SheetDeactivate(ByVal Sh As Object) Set wksLast = Sh End Sub Your Back code will look like this (placed in a sheet or standard code module)... Sub Back() ThisWorkbook.wksLast.Select End Sub -- HTH... Jim Thomlinson "Kees Korver" wrote: Hi all, probably quite simple question, but I can't find the answer ..... In my Excel-application 4 pages (worksheets) exist: for example A,B,C and D Button on page A moves the user to page D A similar button on page B navigates user also to page D Now I wish to implement one button on page D "back" it should move the user back to the originating page, i.e. where he began his journey. In some cases he should go back to A, but sometimes to B. How should Excel remember the starting page?? I tried Dim blabla as Name; blabla = Active.Worksheet.Name then navigate to page D, then return to blabla. But the only thing happening is lots of error messages. I presume the solution could be simple? I am very grateful with an answer! Thanks, Kees -- Kees Korver ------------------------------------------------------------------------ Kees Korver's Profile: http://www.excelforum.com/member.php...o&userid=21562 View this thread: http://www.excelforum.com/showthread...hreadid=558249 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
simple sum question | New Users to Excel | |||
Simple question | New Users to Excel | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
simple question, hopefully a simple answer! | Excel Programming |