Hi Cahm,

Try inserting the following macro in your workbook:

'=============
Private Sub Workbook_Open()
Me.Sheets("Sheet1").Activate
End Sub
'<<=============

This is workbook event code and should be pasted into the workbook's
ThisWorkbook module *not* a standard module or a sheet module):

******************************************
Right-click the Excel icon on the worksheet
(or the icon to the left of the File menu if your workbook is maximised)

Select 'View Code' from the menu and paste the code.

Alt-F11 to return to Excel.
******************************************

Replace Sheet1 with the name of the index sheet if it differs.


---
Regards,
Norman



"CAHM" wrote in message
...
I am using Excel 2003 with several worksheets, the first worksheet being an
index.
There are several users of the document and I was wondering if there was a
way that every time someone opened the workbook it would always open with
the
index being the active worksheet.