Simple VBA question (?)

[Kees Korver]

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

[Jim Thomlinson]

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
>
>