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