Excel 2007 OPEN always Sheet1
Private Sub Workbook_Open()
ThisWorkbook.Sheets("Sheet1").Select
End Sub
Gord Dibben MS Excel MVP
On Thu, 29 Jan 2009 09:29:44 -0800 (PST), Gabito
wrote:
On Jan 27, 9:33*pm, "Fred Smith" wrote:
Yes. Click on the Sheet1tabbefore you save.
Regards,
Fred.
"Gabito" wrote in message
...
In my excel worksheet having more than 3 pages(like sheet1,sheet2...)
I Edit sheet3 and save *next time Iopenthat workbook, it opens on
sheet 3 withsameediting line
Is it possible toALWAYSopenSheet1?- Hide quoted text -
- Show quoted text -
Mmmm, I already knew that, but I will share this spreadsheet with
lot's of users.. I need this to be automatic...
|