Thank you Gord and Barb for the tips. Gord I am unable to paste the
script into the VB screen. In fact 'view code' does not open with
ThisWorbook (code) page? Could the file be protected somehow? If so,
how can fix this.

The person that created the spreadsheet no longer works for the company
and I have taken over her responsibilities.

Thanks again,

Steven

Gord Dibben wrote:
Steven

Private Sub Workbook_Open()
Sheets("2007").Activate
ActiveSheet.Range("C1024").Select
End Sub

With your workbook open, right-click on the Excel logo left of "File" if your
window is maximized or on the title bar Excel logo if not maximized.

Select "View Code" and Thisworkbook module will open.

Paste the code into that module

Close that window. Save your workbook and close it.

Each time you open it, it will open to the worksheet you have named no matter
where you were when you last saved/closed.


Gord Dibben MS Excel MVP

On Mon, 18 Jun 2007 18:22:47 -0500, Steven Hilgendorf
wrote:

Question,

We have a shared workbook that we use to keep track of purchase order
numbers. The workbook contains yearly worksheet tabs (i.e. 2007, 2006,
2005, etc.) The problem is that when some users open the workbook they
have to navigate to the current worksheet (2007) at the end of the list
to enter the next purchase order.

It does not matter if the user saves the workbook in the current
worksheet (2007) at the end of the list, say cell C1024 of the 2007 tab.
The next time they open the workbook it defaults back to a different
worksheet in a different location. Different users startup in different
locations and worksheets.

How can the users save the file so that when they open it they are in
the current year worksheet at the end of the list?

Thank you,

Steven