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.

On Nov 16, 9:32 am, 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.

When you save the document the last save you make is where the
document will open next time

Brandon

I guess if you are on the sheet you want to open, just save the workbook and
close it Next time when you open, you should see the same sheet.

Dont know if there is an easier way of doing this.

"harwookf" wrote in message
...
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.

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

This works if I am the only one using the worksheet, but not when you have to
rely on others.
Am going to try the macro given by Dave Peterson, but thanks for your
response.

Cheers


"Brandon G." wrote:

On Nov 16, 9:32 am, 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.

When you save the document the last save you make is where the
document will open next time

Brandon

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