View Single Post
  #3   Report Post  
FxM
 
Posts: n/a
Default open at define work sheet

kit wrote:
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


Hi Kitty,

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

@+
FxM