Direct to sheet

  • Thread starter Thread starter Gazz_85
  • Start date Start date
G

Gazz_85

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting data but keep formulas/formatting. 3
share workbook is greyed out 1
SHEET SET UP 9
Sorting data in protected sheets? 1
Excel - VBA - workbook/worksheet navigation 1
is there an auto-numbering tax invoice templete for excel 1
Import data from four columns to single column in new sheet 1
Encrypted Workbook 1

Back
Top