Open Excel ... Select WorkSheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

In the Thisworkbook code module:

Private Sub Workbook_Open()
ThisWorkbook.Sheets(Format(Date, "mmm")).Activate
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum multiple sheets? 1
Auto Chg Tab Color vs Current Month 4
Use Workbook tabs in a Worksheet 1
Excel Format vs Import from SAP 2
Tie additional cells to cell automatically updated 1
Look up in another sheet for values to return in 1st worksheet 2
Excel 2003 Referencing multiple worksheets 3
Combine 6 worksheets into 1 worksheet - Summary 1

Back
Top