does excel all ways want to open on sheet (1) is there a way to change it.
Know I cna copy all data to another sheet. That means I have a lot of
references to change also. This is reason to change opening page.
Thanks

you can create an auto open macro
in a code module:

Sub auto_open()
Worksheets("sheet2").Select
End Sub



--


Gary


"Curt" wrote in message
...
does excel all ways want to open on sheet (1) is there a way to change it.
Know I cna copy all data to another sheet. That means I have a lot of
references to change also. This is reason to change opening page.
Thanks

Let's say whenever you open a certain workbook you want to open on a sheet
named "Special"

In ThisWorkbook code enter the following:

Private Sub Workbook_Open()
Sheets("Special").Activate
End Sub

--
Gary's Student
gsnu200702


"Curt" wrote:

does excel all ways want to open on sheet (1) is there a way to change it.
Know I cna copy all data to another sheet. That means I have a lot of
references to change also. This is reason to change opening page.
Thanks

Hi Curt,

I don't believe you can change the default sheet name on a standard Excel
startup.

You could create a file with the appropriate sheet name and store it in the
XLStart folder. This file will open on start as your default workbook. The
folder is located at:

C:\Program Files\Microsoft Office\Office10\XLStart

This is the start location for Excel 2002 (XP), yours may differ slightly if
you are running a different version.


Alan





"The only dumb question is the question left unasked."

"Curt" wrote in message
...
does excel all ways want to open on sheet (1) is there a way to change it.
Know I cna copy all data to another sheet. That means I have a lot of
references to change also. This is reason to change opening page.
Thanks

Suprise I just tried this. Insert a new wks and it becomes nbr1 whaen others
are named. So I got my fresh sheet to make opening.
Thanks Guy's
Get my sort problem and I will be able to complete



"Gary''s Student" wrote:

Let's say whenever you open a certain workbook you want to open on a sheet
named "Special"

In ThisWorkbook code enter the following:

Private Sub Workbook_Open()
Sheets("Special").Activate
End Sub

--
Gary's Student
gsnu200702


"Curt" wrote:

does excel all ways want to open on sheet (1) is there a way to change it.
Know I cna copy all data to another sheet. That means I have a lot of
references to change also. This is reason to change opening page.
Thanks