Create a macro using the Workbook_Open event in the thisworkbook module

http://www.cpearson.com/excel/events.htm
Chip Pearson's page on events
--
Regards,
Tom Ogilvy

"Charlie" wrote in message
...
I have a shared workbook that employees enter data on several sheets.
When
an employee exits the workbook and another employee opens the workbook it
comes up on the last sheet modified by the previous employee. Is there a
way
to set the workbook to always open with the focus on Sheet1? Or do I have
to
create a macro to do this?

Thanks.