| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to automatically update a second worksheet when data inserted | Excel Worksheet Functions | |||
| symbols automatically inserted | Excel Discussion (Misc queries) | |||
| Macro add worksheet to workbook automatically | Excel Discussion (Misc queries) | |||
| How can I get inserted lines to automatically appear in a linked . | Excel Worksheet Functions | |||
| Can inserted rows automatically include existing worksheet formula | Excel Discussion (Misc queries) | |||
![darkcity1965[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
