Spreadsheet Tabs
 

Is there a way that when you open a file it will automatically go to the
first tab?

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?

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?

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?