View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Smallweed Smallweed is offline
external usenet poster
 
Posts: 133
Default Open workbook to specific worksheet

Put the following into the ThisWorkbook module:

Private Sub Workbook_Open()
Sheets(Format(Now, "mmmm")).Activate
End Sub

I'm assuming you've called the sheets January, February etc.

"mathel" wrote:

I think there is an easy solution to this, but I can't find it.

I have a workbook divided into 12 worksheets, one for each month. On
opening the workbook, I would like it to open at the worksheet for the
current month.

Can anyone help with a code for this?

Thanks
--
Linda