When I open Excel I want it to open on Sheet 1
 

OK, I have an excel file that many employees use and save thier information
in. If an employees enters info into sheet 4 and then saves it, when the
next employee opens the same file it will open directly to sheet 4. This
file has a "cover page" which is sheet 1. I always want excel to open up to
sheet 1 no matter what sheet it was previously saved in. Is this possible?

When I open Excel I want it to open on Sheet 1
 

Right-click on the Excel logo left of "File" or at left end of Title bar if not
maximized.

Select "View Code" and paste this into that module.

Private Sub Workbook_Open()
ThisWorkbook.Sheets("Sheet1").Activate
End Sub

If you want to go to a particular cell and have that cell be top left.
Pick a cell on Sheet1 and InsertNameDefine.
Name it Start then use this sub instead

Private Sub Workbook_Open()
Application.Goto Reference:="Start", Scroll:=True
End Sub


Gord Dibben MS Excel MVP

On Tue, 23 Jan 2007 12:52:00 -0800, traveye
wrote:

OK, I have an excel file that many employees use and save thier information
in. If an employees enters info into sheet 4 and then saves it, when the
next employee opens the same file it will open directly to sheet 4. This
file has a "cover page" which is sheet 1. I always want excel to open up to
sheet 1 no matter what sheet it was previously saved in. Is this possible?

When I open Excel I want it to open on Sheet 1
 

Add this to the "ThisWorkbook" module:
(Alt-F11 to open VB editor expand Project & ExcelObjects dblClick
ThisWorkbook entry copy & paste in code window. Save.)

Private Sub Workbook_Open()
ThisWorkbook.Worksheets("Sheet1").Activate
End Sub

Change "Sheet1" to the name of your cover page as the User sees it.

Note: you now have code in your workbook. Users can choose not to enable
macros, so it isn't foolproof, but I'm not aware of any way to do what you
want that wouldn't envolve coding.

HTH,

"traveye" wrote in message
...
OK, I have an excel file that many employees use and save thier
information
in. If an employees enters info into sheet 4 and then saves it, when the
next employee opens the same file it will open directly to sheet 4. This
file has a "cover page" which is sheet 1. I always want excel to open up
to
sheet 1 no matter what sheet it was previously saved in. Is this possible?

When I open Excel I want it to open on Sheet 1
 

Hi George
You can add the line
Application.DisplayAlerts=False

to disable the macro message from appearing

Regards
Michael M

"George Nicholson" wrote:

Add this to the "ThisWorkbook" module:
(Alt-F11 to open VB editor expand Project & ExcelObjects dblClick
ThisWorkbook entry copy & paste in code window. Save.)

Private Sub Workbook_Open()
ThisWorkbook.Worksheets("Sheet1").Activate
End Sub

Change "Sheet1" to the name of your cover page as the User sees it.

Note: you now have code in your workbook. Users can choose not to enable
macros, so it isn't foolproof, but I'm not aware of any way to do what you
want that wouldn't envolve coding.

HTH,

"traveye" wrote in message
...
OK, I have an excel file that many employees use and save thier
information
in. If an employees enters info into sheet 4 and then saves it, when the
next employee opens the same file it will open directly to sheet 4. This
file has a "cover page" which is sheet 1. I always want excel to open up
to
sheet 1 no matter what sheet it was previously saved in. Is this possible?

When I open Excel I want it to open on Sheet 1
 

Michael

Info only...........

The "This workbook contains macros" message appears long before any code runs.

It appears when you first open the workbook and Excel notices the file contains
macros or even an empty module.

No way to turn that mesage off unless you change security to "Low" which is not
a good idea, or digitally sign the workbook.


Gord Dibben MS Excel MVP

On Tue, 23 Jan 2007 13:51:01 -0800, Michael M
wrote:

Hi George
You can add the line
Application.DisplayAlerts=False

to disable the macro message from appearing

Regards
Michael M

"George Nicholson" wrote:

Add this to the "ThisWorkbook" module:
(Alt-F11 to open VB editor expand Project & ExcelObjects dblClick
ThisWorkbook entry copy & paste in code window. Save.)

Private Sub Workbook_Open()
ThisWorkbook.Worksheets("Sheet1").Activate
End Sub

Change "Sheet1" to the name of your cover page as the User sees it.

Note: you now have code in your workbook. Users can choose not to enable
macros, so it isn't foolproof, but I'm not aware of any way to do what you
want that wouldn't envolve coding.

HTH,

"traveye" wrote in message
...
OK, I have an excel file that many employees use and save thier
information
in. If an employees enters info into sheet 4 and then saves it, when the
next employee opens the same file it will open directly to sheet 4. This
file has a "cover page" which is sheet 1. I always want excel to open up
to
sheet 1 no matter what sheet it was previously saved in. Is this possible?

When I open Excel I want it to open on Sheet 1
 

Gord
Thanks for the heads up.
Just when I thought I was getting smarter !!
Regards
Michael M

"Gord Dibben" wrote:

Michael

Info only...........

The "This workbook contains macros" message appears long before any code runs.

It appears when you first open the workbook and Excel notices the file contains
macros or even an empty module.

No way to turn that mesage off unless you change security to "Low" which is not
a good idea, or digitally sign the workbook.


Gord Dibben MS Excel MVP

On Tue, 23 Jan 2007 13:51:01 -0800, Michael M
wrote:

Hi George
You can add the line
Application.DisplayAlerts=False

to disable the macro message from appearing

Regards
Michael M

"George Nicholson" wrote:

Add this to the "ThisWorkbook" module:
(Alt-F11 to open VB editor expand Project & ExcelObjects dblClick
ThisWorkbook entry copy & paste in code window. Save.)

Private Sub Workbook_Open()
ThisWorkbook.Worksheets("Sheet1").Activate
End Sub

Change "Sheet1" to the name of your cover page as the User sees it.

Note: you now have code in your workbook. Users can choose not to enable
macros, so it isn't foolproof, but I'm not aware of any way to do what you
want that wouldn't envolve coding.

HTH,

"traveye" wrote in message
...
OK, I have an excel file that many employees use and save thier
information
in. If an employees enters info into sheet 4 and then saves it, when the
next employee opens the same file it will open directly to sheet 4. This
file has a "cover page" which is sheet 1. I always want excel to open up
to
sheet 1 no matter what sheet it was previously saved in. Is this possible?

When I open Excel I want it to open on Sheet 1
 

Thanks to All, You guys are awesome!

"Michael M" wrote:

Gord
Thanks for the heads up.
Just when I thought I was getting smarter !!
Regards
Michael M

"Gord Dibben" wrote:

Michael

Info only...........

The "This workbook contains macros" message appears long before any code runs.

It appears when you first open the workbook and Excel notices the file contains
macros or even an empty module.

No way to turn that mesage off unless you change security to "Low" which is not
a good idea, or digitally sign the workbook.


Gord Dibben MS Excel MVP

On Tue, 23 Jan 2007 13:51:01 -0800, Michael M
wrote:

Hi George
You can add the line
Application.DisplayAlerts=False

to disable the macro message from appearing

Regards
Michael M

"George Nicholson" wrote:

Add this to the "ThisWorkbook" module:
(Alt-F11 to open VB editor expand Project & ExcelObjects dblClick
ThisWorkbook entry copy & paste in code window. Save.)

Private Sub Workbook_Open()
ThisWorkbook.Worksheets("Sheet1").Activate
End Sub

Change "Sheet1" to the name of your cover page as the User sees it.

Note: you now have code in your workbook. Users can choose not to enable
macros, so it isn't foolproof, but I'm not aware of any way to do what you
want that wouldn't envolve coding.

HTH,

"traveye" wrote in message
...
OK, I have an excel file that many employees use and save thier
information
in. If an employees enters info into sheet 4 and then saves it, when the
next employee opens the same file it will open directly to sheet 4. This
file has a "cover page" which is sheet 1. I always want excel to open up
to
sheet 1 no matter what sheet it was previously saved in. Is this possible?

When I open Excel I want it to open on Sheet 1
 

It Works!

Thanks to All, You guys are awesome!

"Michael M" wrote:

Gord
Thanks for the heads up.
Just when I thought I was getting smarter !!
Regards
Michael M

"Gord Dibben" wrote:

Michael

Info only...........

The "This workbook contains macros" message appears long before any code runs.

It appears when you first open the workbook and Excel notices the file contains
macros or even an empty module.

No way to turn that mesage off unless you change security to "Low" which is not
a good idea, or digitally sign the workbook.


Gord Dibben MS Excel MVP

On Tue, 23 Jan 2007 13:51:01 -0800, Michael M
wrote:

Hi George
You can add the line
Application.DisplayAlerts=False

to disable the macro message from appearing

Regards
Michael M

"George Nicholson" wrote:

Add this to the "ThisWorkbook" module:
(Alt-F11 to open VB editor expand Project & ExcelObjects dblClick
ThisWorkbook entry copy & paste in code window. Save.)

Private Sub Workbook_Open()
ThisWorkbook.Worksheets("Sheet1").Activate
End Sub

Change "Sheet1" to the name of your cover page as the User sees it.

Note: you now have code in your workbook. Users can choose not to enable
macros, so it isn't foolproof, but I'm not aware of any way to do what you
want that wouldn't envolve coding.

HTH,

"traveye" wrote in message
...
OK, I have an excel file that many employees use and save thier
information
in. If an employees enters info into sheet 4 and then saves it, when the
next employee opens the same file it will open directly to sheet 4. This
file has a "cover page" which is sheet 1. I always want excel to open up
to
sheet 1 no matter what sheet it was previously saved in. Is this possible?