Ian,

You will need to add the following line to the workbook_open event i
the thisworkbook code module so you have something that looks like.

Private Sub Workbook_Open()
Sheets("sheet1").Activate

End Sub


ianripping wrote:
*Is there a macro that would direct the user to "Sheet1" every tim
the workbook is opened and where would you place the macro? *

*HTH

--
Message posted from http://www.ExcelForum.com