| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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... |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open UTF-8 in Excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 won't open normally. | Excel Discussion (Misc queries) | |||
| slow to open Excel 2007 and Word 2007 (MIS stumped) | Excel Discussion (Misc queries) | |||
| Help open Excel 2007 | New Users to Excel | |||
| [=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') | Excel Worksheet Functions | |||
Linear Mode
