Shared workbook - opening to the correct worksheet
 

We are using Shared workbooks to track (payroll) time.

Each week ending, receives its own Excel worksheet.

The problem: Whenever the employee opens the workbook, it defaults to the
last worksheet that was touched... when the Excel workbook was originally (or
re-designated) and saved as a "shared workbook". We would like it to work
such that the individual employee's last "save" indicates what worksheet the
workbook opens to...

any ideas? Thanks in advance,
Beata