ExcelBanter - Direct to sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Direct to sheet (https://www.excelbanter.com/excel-discussion-misc-queries/236435-direct-sheet.html)

how do i sort it ao that when a wookbook is opened it automatically shows the
sheet that is the navigation sheet.

Hi,
Not sure what you want try positioning in the navigation sheet and save it
before closing

"Gazz_85" wrote:

how do i sort it ao that when a wookbook is opened it automatically shows the
sheet that is the navigation sheet.

I understand you want to activiate the navigation sheet always.. Try pasting
the below code. Press Alt+F11 from workbook to launch VBE. From the left
treeview double click on 'This Workbook' and paste the below code to the code
pane. Type in your navigation sheet name within the double quotes..Save and
close.. Get back to workbook. Try opening the workbook after saving from a
different sheet.

Private Sub Workbook_Open()
Me.Sheets("TypeyourSheetname").Activate
End Sub

If this post helps click Yes
---------------
Jacob Skaria

"Gazz_85" wrote:

how do i sort it ao that when a wookbook is opened it automatically shows the
sheet that is the navigation sheet.