View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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...