Excel 2007 OPEN always Sheet1

[Gabito]

In my excel worksheet having more than 3 pages(like sheet1,sheet2...)
I Edit sheet3 and save next time I open that workbook, it opens on
sheet 3 with same editing line
Is it possible to ALWAYS open Sheet1?

 

[Fred Smith]

Yes. Click on the Sheet1 tab before you save.

Regards,
Fred.

 

[Gabito]

Yes. Click on the Sheet1tabbefore you save.

Regards,
Fred.






- 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...

 

[Fred Smith]

Then you need a macro.

Regards,
Fred.

Yes. Click on the Sheet1tabbefore you save.

Regards,
Fred.






- 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...

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP