automatically go to last worksheet inserted in a workbook.

[darkcity1965]

Can somebody please tell me how upon opening a workbook the last sheet that was inserted is the active sheet.

Thankyou

[alf bryn]

Depends on where the last sheet was inserted. If it is inserted as the last
sheet (i.e you have 3 sheets in the workbook and inserts a 4th sheet after
sheet 3)
then this macro is a possible solution.

Sub Auto_Open()
'
Dim i As Integer

i = Sheets.Count

Sheets(i).Select

End Sub


"darkcity1965" <[email protected]>
wrote in message
news:[email protected]...
>
> Can somebody please tell me how upon opening a workbook the last sheet
> that was inserted is the active sheet.
>
> Thankyou
>
>
> --
> darkcity1965
> ------------------------------------------------------------------------
> darkcity1965's Profile:
> http://www.excelforum.com/member.php...o&userid=15712
> View this thread: http://www.excelforum.com/showthread...hreadid=382484
>

[darkcity1965]

It will be inserted as the last sheet. All other sheet tabs will be to the left of it. There will also be a new sheet inserted each week.

[alf bryn]

In this case there should be no problem with the macro I suggested since
this macro counts all the sheets in a workbook working from left to right.



"darkcity1965" <[email protected]>
wrote in message
news:[email protected]...
>
> It will be inserted as the last sheet. All other sheet tabs will be to
> the left of it. There will also be a new sheet inserted each week.
>
>
> --
> darkcity1965
> ------------------------------------------------------------------------
> darkcity1965's Profile:
> http://www.excelforum.com/member.php...o&userid=15712
> View this thread: http://www.excelforum.com/showthread...hreadid=382484
>