Force excel to open on a specific sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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.
 
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
 
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
 
Back
Top