Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening Workbook at Certain Place
I'd like to open a workbook to a certain place each time it's opened. I won't
be the one using it - I'm just the one designing it and I know that the person using it won't close the workbook with the active cell on the first page of the workbook. Is there way or a macro that will automatically open the workbook with the active cell in A1 on the first page?? I'd appreciate any help you have to offer! Thanks! Elise |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening Workbook at Certain Place
Maybe this.........
Private Sub Workbook_Open() Sheets("sheet1").Select Range("A1").Select End Sub hth Vaya con Dios, Chuck, CABGx3 "Elise148" wrote: I'd like to open a workbook to a certain place each time it's opened. I won't be the one using it - I'm just the one designing it and I know that the person using it won't close the workbook with the active cell on the first page of the workbook. Is there way or a macro that will automatically open the workbook with the active cell in A1 on the first page?? I'd appreciate any help you have to offer! Thanks! Elise |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening Workbook at Certain Place
Thanks!
"Gord Dibben" wrote: The following will activate the sheet you want and leave A1 selected at top left of sheet. Edit "Mysheet" to your sheetname. Private Sub Workbook_Open() Sheets("Mysheet").Activate Application.Goto Reference:=Range("A1"), Scroll:=True End Sub With your workbook open, right-click on the Excel logo left of "File" if your window is maximized or on the title bar Excel logo if not maximized. Select "View Code" and Thisworkbook module will open. Paste the code into that module Close that window. Save your workbook and close it. Each time you open it, it will open to the worksheet you have named no matter where you were when you last saved/closed. Gord Dibben MS Excel MVP On Thu, 12 Jul 2007 11:54:00 -0700, Elise148 wrote: I'd like to open a workbook to a certain place each time it's opened. I won't be the one using it - I'm just the one designing it and I know that the person using it won't close the workbook with the active cell on the first page of the workbook. Is there way or a macro that will automatically open the workbook with the active cell in A1 on the first page?? I'd appreciate any help you have to offer! Thanks! Elise |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening Workbook at Certain Place
The following will activate the sheet you want and leave A1 selected at top left
of sheet. Edit "Mysheet" to your sheetname. Private Sub Workbook_Open() Sheets("Mysheet").Activate Application.Goto Reference:=Range("A1"), Scroll:=True End Sub With your workbook open, right-click on the Excel logo left of "File" if your window is maximized or on the title bar Excel logo if not maximized. Select "View Code" and Thisworkbook module will open. Paste the code into that module Close that window. Save your workbook and close it. Each time you open it, it will open to the worksheet you have named no matter where you were when you last saved/closed. Gord Dibben MS Excel MVP On Thu, 12 Jul 2007 11:54:00 -0700, Elise148 wrote: I'd like to open a workbook to a certain place each time it's opened. I won't be the one using it - I'm just the one designing it and I know that the person using it won't close the workbook with the active cell on the first page of the workbook. Is there way or a macro that will automatically open the workbook with the active cell in A1 on the first page?? I'd appreciate any help you have to offer! Thanks! Elise |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
move a sheet out of my workbook and place in another folder? | Excel Discussion (Misc queries) | |||
1 workbook, 4 worksheets, want to add rows in same place in all WS | Excel Discussion (Misc queries) | |||
Opening workbook | Excel Discussion (Misc queries) | |||
How to prevent any one from opening my workbook | New Users to Excel | |||
Keeping cursor in same place on all worksheets in a workbook | Excel Worksheet Functions |