Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Spreadsheet Tabs
Is there a way that when you open a file it will automatically go to the
first tab? |
#2
|
|||
|
|||
Spreadsheet Tabs
Deena,
If you're familiar with VBA and Macros, one of the easiest ways is to put the following line into the 'Open' event of your workbook: Sheets("Sheet1").Select You will need to change 'Sheet1' to the name of the worksheet you want to select, but this means that it doesn't necessarily have to be the first sheet, it can be anywhere in the sequence you like. If you're not familiar with VBA, there are plenty of beginners tutorials around that will give you enough of a start to get you going. HTH Neil www.nwarwick.co.uk "Deena" wrote: Is there a way that when you open a file it will automatically go to the first tab? |
#3
|
|||
|
|||
Spreadsheet Tabs
Private Sub Workbook_Open()
Worksheets(1).Select End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- HTH RP (remove nothere from the email address if mailing direct) "Deena" wrote in message ... Is there a way that when you open a file it will automatically go to the first tab? |
#4
|
|||
|
|||
Spreadsheet Tabs
I changed the information as described below; but, it still will not open to
the tab that I specified. Any suggestions? "Neil" wrote: Deena, If you're familiar with VBA and Macros, one of the easiest ways is to put the following line into the 'Open' event of your workbook: Sheets("Sheet1").Select You will need to change 'Sheet1' to the name of the worksheet you want to select, but this means that it doesn't necessarily have to be the first sheet, it can be anywhere in the sequence you like. If you're not familiar with VBA, there are plenty of beginners tutorials around that will give you enough of a start to get you going. HTH Neil www.nwarwick.co.uk "Deena" wrote: Is there a way that when you open a file it will automatically go to the first tab? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to handle multiple currencies with one spreadsheet | Excel Discussion (Misc queries) | |||
Using Excel spreadsheet as input to Access | Excel Discussion (Misc queries) | |||
Spreadsheet merging problems | Excel Worksheet Functions | |||
Linkage data between two spreadsheet | Excel Worksheet Functions | |||
Delay to startup excel spreadsheet | Excel Worksheet Functions |