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