Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
1st sheet being displayed
Hello
is there is any way so that whenever i open my workbook i see the first sheet wich is the main sheet with all the employees name on it they click on their names and it will be linked to their sheet but what ever y open it the last sheet opened will be displayed not the main Is there is any way it shows the main everytime you open ? Tia |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
1st sheet being displayed
Click on Tools - Macro - Visual Basic Editor
In the Left Hand Project Pane, Double Click ThisWorkbook In the Workbook Open Event, put the code below & then Exit and Save the Workbook. Open it again and the first sheet should be displayed. Private Sub Workbook_Open() Me.Sheets(1).Select End Sub "Tia" wrote: Hello is there is any way so that whenever i open my workbook i see the first sheet wich is the main sheet with all the employees name on it they click on their names and it will be linked to their sheet but what ever y open it the last sheet opened will be displayed not the main Is there is any way it shows the main everytime you open ? Tia |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
1st sheet being displayed
On Jul 1, 1:21*pm, Dennis wrote:
Click on Tools - Macro - Visual Basic Editor In the Left Hand Project Pane, Double Click ThisWorkbook In the Workbook Open Event, put the code below & then Exit and Save the Workbook. Open it again and the first sheet should be displayed. Private Sub Workbook_Open() * * Me.Sheets(1).Select End Sub "Tia" wrote: Hello is there is any way so that whenever i open my workbook i see the first sheet wich is the main sheet with all the employees name on it they click on their names and it will be linked to their sheet but what ever y open it the last sheet opened will be displayed not the main Is there is any way it shows the main everytime you open ? Tia- Hide quoted text - - Show quoted text - Ok i went to developer visual basic i double clicked on the view excel file and than view code and and i copy and paste it Im doing something wrong b its not working can you help me please im not good in visual basic Tia |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
1st sheet being displayed
I cannot see what you have done wrong so I don't know what to suggest.
What do you mean by double clicked on the "View Excel File" ? You need to double click on the 'ThisWorkbook' usually at the bottom of a list of worksheet names on the left hand side of the screen. You should then paste the code on the right hand pane. "Tia" wrote: On Jul 1, 1:21 pm, Dennis wrote: Click on Tools - Macro - Visual Basic Editor In the Left Hand Project Pane, Double Click ThisWorkbook In the Workbook Open Event, put the code below & then Exit and Save the Workbook. Open it again and the first sheet should be displayed. Private Sub Workbook_Open() Me.Sheets(1).Select End Sub "Tia" wrote: Hello is there is any way so that whenever i open my workbook i see the first sheet wich is the main sheet with all the employees name on it they click on their names and it will be linked to their sheet but what ever y open it the last sheet opened will be displayed not the main Is there is any way it shows the main everytime you open ? Tia- Hide quoted text - - Show quoted text - Ok i went to developer visual basic i double clicked on the view excel file and than view code and and i copy and paste it Im doing something wrong b its not working can you help me please im not good in visual basic Tia |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
1st sheet being displayed
Right-click on the Excel Icon left of "File" on the worksheet menu bar.
Select "View Code" to open Thisworkbook module. Paste the code into that module. Alt + q to return to the Excel window. Select any sheet but "Main". Save, close and re-open. Gord Dibben MS Excel MVP On Tue, 1 Jul 2008 04:18:38 -0700 (PDT), Tia wrote: On Jul 1, 1:21*pm, Dennis wrote: Click on Tools - Macro - Visual Basic Editor In the Left Hand Project Pane, Double Click ThisWorkbook In the Workbook Open Event, put the code below & then Exit and Save the Workbook. Open it again and the first sheet should be displayed. Private Sub Workbook_Open() * * Me.Sheets(1).Select End Sub "Tia" wrote: Hello is there is any way so that whenever i open my workbook i see the first sheet wich is the main sheet with all the employees name on it they click on their names and it will be linked to their sheet but what ever y open it the last sheet opened will be displayed not the main Is there is any way it shows the main everytime you open ? Tia- Hide quoted text - - Show quoted text - Ok i went to developer visual basic i double clicked on the view excel file and than view code and and i copy and paste it Im doing something wrong b its not working can you help me please im not good in visual basic Tia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to copy displayed value only? | Excel Worksheet Functions | |||
when I type 1 it is displayed as 0.01 | Excel Worksheet Functions | |||
opening sheet, next available cell displayed | New Users to Excel | |||
Fill colors aren't displayed in my Spread sheet but they print. | Excel Worksheet Functions | |||
If A1 has a #, that is displayed, if D1 has a # that is displayed | Excel Worksheet Functions |