Many thanks for your help on this, it works a treat.

Cheers



"Dave Peterson" wrote:

You could use a macro:

This goes in a General module--not under ThisWorkbook and not behind a
worksheet:

Option Explicit
Sub Auto_Open()
application.goto thisworkbook.worksheets("sheetnamehere").range("a1 "), _
scroll:=true
End sub

Change the sheetnamehere to what you want.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

harwookf wrote:

Is there a way to force excel to open on a specific sheet?

I have 4 worksheets within the workbook, but need it to always open on a
certain one.

--

Dave Peterson