Force excel to open on a specific sheet

[Guest]

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.

 

[Brandon G.]

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

 

[Gaurav]

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.

 

[Dave Peterson]

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

 

[Guest]

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

 

[Guest]

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

Cheers