| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open Excel ... Select WorkSheet
Excel2003 ... I previously submitted a 2 question post ... However, only 1
question answered ... That said ... I am back. I have 12 WorkSheets ... Jan, Feb Mar etc ... When I open my WorkBook ... I wish for the current Month WorkSheet to be selected. I am assuming I need a little Code from the Code writers ... Thanks ... Kha |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Open Excel ... Select WorkSheet
Ken,
In the Thisworkbook code module: Private Sub Workbook_Open() ThisWorkbook.Sheets(Format(Date, "mmm")).Activate End Sub -- Hope that helps. Vergel Adriano "Ken" wrote: Excel2003 ... I previously submitted a 2 question post ... However, only 1 question answered ... That said ... I am back. I have 12 WorkSheets ... Jan, Feb Mar etc ... When I open my WorkBook ... I wish for the current Month WorkSheet to be selected. I am assuming I need a little Code from the Code writers ... Thanks ... Kha |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot select a chart on an Excel worksheet | Charts and Charting in Excel | |||
| Open Workbook - Select Range as table for vlookup | Excel Discussion (Misc queries) | |||
| In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
| In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
| When I select "Open" from the "File" menu in Excel, I get only a . | Excel Discussion (Misc queries) | |||
Hybrid Mode
