Open Workbook at specified worksheet

[SD8146]

Does anyone have the code to open a Microsoft Excel workbook at a specified worksheet please - I have a menu page with links to other areas of the workbook and would like to be able to have it always open into the menu page.

Many thanks

 

[Chance1234]

under this workbook
replace sheet1 with whatever sheet your menu is on,.

Private Sub Workbook_Open()
    Sheet1.Activate
End Sub

Chance,

Filmmaker, taken gentleman and He tan e epi tas