You did not say what version of Excel. This applies to XL 2003 (and down to
XL 1997)
1 Right click the green X Excel logo to the left of the File item on the
menu
2 Select View Code
3 Copy this subroutine into the module window
Private Sub Workbook_Open()
Sheets("Sheet3").Select
End Sub

4 Modify the middle line to suit your needs
5 You many need to reset you macro security for the subroutine to run when
you open the file
bet wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"Greg Sottile" wrote in message
...
I have a workbook with multiple worksheets. Upon open, can I force a
specific worksheet to be current? Typically which ever sheet was current
when last saved is the current sheet on open.