View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paul Paul is offline
external usenet poster
 
Posts: 16
Default Open at same sheet everytime

Hi,

I have a workbook with over 20 sheets used by multiple users. How
can I get Excel to open at an index page everytime (instead of
opening
on the last page that was saved)

Joel kindly gave me the following information
Private Sub App_WorkbookOpen(ByVal Wb As Workbook)
* * ThisWorkbook.Sheets("Sheet2").Activate
End Sub

I placed this in the Sheet2 and also in the 'This workbook' within VBA
and both did not work.

The name of my sheet is Help and I changed "Sheet2" to help - no joy.

What am I doing wrong - Thanks