Yep,

Press Alt + F11 to bring up the VB editor, find your workbook in the project
window and right click it then "View Code" - paste this in:

Private Sub Workbook_Open()

worksheets("Whatever Sheet you want").activate

End Sub


Sam

"Greg Sottile" wrote:

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.