open at define work sheet

K

kit

Iwant a shared workbook to always open at a define work sheet (Front page).
I have entered the following in vb under workbook but it does not work. I
entered the following
Private Sub Workbook_Open(sheets "front page".select)
End Sub
please help
Kitty
 
C

Chip Pearson

Put the following code in the ThisWorkbook code module:

Private Sub Workbook_Open()
Me.Worksheets("Front Page").Select
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
F

FxM

kit said:
Iwant a shared workbook to always open at a define work sheet (Front page).
I have entered the following in vb under workbook but it does not work. I
entered the following
Private Sub Workbook_Open(sheets "front page".select)
End Sub
please help
Kitty
Click to expand...

Hi Kitty,

Were not too far :
Private Sub Workbook_Open()
sheets("front page").select
'can try also :
sheets("front page").activate
End Sub

@+
FxM
 
K

kit

Works brilliantly, thank you
Kit

Chip Pearson said:
Put the following code in the ThisWorkbook code module:

Private Sub Workbook_Open()
Me.Worksheets("Front Page").Select
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Click to expand...
 
Top