Thread
:
Opening excel
View Single Post
#
5
Posted to microsoft.public.excel.programming
Curt
external usenet poster
Posts: 469
Opening excel
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
Reply With Quote
Curt
View Public Profile
Find all posts by Curt