action on open

[Greg Sottile]

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.

 

[Sam Wilson]

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

 

[Bernard Liengme]

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