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.

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.

You need code

Private Sub Workbook_Open()
Worksheets("Sheet1").Activate
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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.