automatically go to last worksheet inserted in a workbook.
 

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

Thankyo

--
darkcity196
-----------------------------------------------------------------------
darkcity1965's Profile: http://www.excelforum.com/member.php...fo&userid=1571
View this thread: http://www.excelforum.com/showthread.php?threadid=38248

automatically go to last worksheet inserted in a workbook.
 

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"
wrote in message
news:darkcity1965.1rag6i_1119881117.6021@excelforu m-nospam.com...

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

automatically go to last worksheet inserted in a workbook.
 

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

--
darkcity196
-----------------------------------------------------------------------
darkcity1965's Profile: http://www.excelforum.com/member.php...fo&userid=1571
View this thread: http://www.excelforum.com/showthread.php?threadid=38248

automatically go to last worksheet inserted in a workbook.
 

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"
wrote in message
news:darkcity1965.1rc2ig_1119956718.0871@excelforu m-nospam.com...

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