D
Deena
Is there a way that when you open a file it will automatically go to the
first tab?
first tab?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Neil
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
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
B
Bob Phillips
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)
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)
D
Deena
I changed the information as described below; but, it still will not open to
the tab that I specified. Any suggestions?
the tab that I specified. Any suggestions?