Excel 2007 OPEN always Sheet1
 

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?

Excel 2007 OPEN always Sheet1
 

Yes. Click on the Sheet1 tab before 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 I open that workbook, it opens on
sheet 3 with same editing line
Is it possible to ALWAYS open Sheet1?

Excel 2007 OPEN always Sheet1
 

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

Excel 2007 OPEN always Sheet1
 

Then you need a macro.

Regards,
Fred.

"Gabito" wrote in message
...
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...

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