I'm using Excel 2003 and trying to figure out how I can open to a specific
worksheet within the workbook. For example, I have tabs with Jan-Dec. I
want to set the workbook to open to the March worksheet automatically. Then
next month I want to change that setting so it will automatically open to the
April worksheet.

Is there a way to make Excel do that?

Thanks.

Todd

Option Explicit
Sub Auto_Open()
on error resume next
application.goto thisworkbook.worksheets(format(date,"mmm")).range( "a1"), _
scroll:=true
if err.number < 0 then
beep
err.clear
end if
on error goto 0
End Sub

This goes in a General module--not behind a worksheet, not behind ThisWorkbook.


Todd wrote:

I'm using Excel 2003 and trying to figure out how I can open to a specific
worksheet within the workbook. For example, I have tabs with Jan-Dec. I
want to set the workbook to open to the March worksheet automatically. Then
next month I want to change that setting so it will automatically open to the
April worksheet.

Is there a way to make Excel do that?

Thanks.

Todd

--

Dave Peterson

Yes. The workbook will open to the worksheet that was active when the
workbook was saved. So just save it with the desired worksheet active.

Tyro

"Todd" wrote in message
...
I'm using Excel 2003 and trying to figure out how I can open to a specific
worksheet within the workbook. For example, I have tabs with Jan-Dec. I
want to set the workbook to open to the March worksheet automatically.
Then
next month I want to change that setting so it will automatically open to
the
April worksheet.

Is there a way to make Excel do that?

Thanks.

Todd