Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Direct to sheet
how do i sort it ao that when a wookbook is opened it automatically shows the
sheet that is the navigation sheet. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Direct to 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Direct to 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to direct to a cell from text | Excel Discussion (Misc queries) | |||
Can you direct me. | Excel Discussion (Misc queries) | |||
MS Query Direct Invoking? | Excel Discussion (Misc queries) | |||
Direct reference | Excel Worksheet Functions | |||
Emailing XML direct from Excel | Excel Discussion (Misc queries) |