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
|