| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook Opening in Certain Place
I posted something yesterday and the suggestions I got were good, but they
did not work. What I want to do is everytime a workbook is opened, have it be opened to a certain place...A1 of the first sheet. I am not the one that will be using this spreadsheet, I'm just designing it, and I know that the person using it will not know to save it in A1 of the first sheet before closing it...how would I go about doing this...go about programming it into VBA? Thanks... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook Opening in Certain Place
Try putting this code into the "ThisWorkbook" code
Private Sub Workbook_Open() ThisWorkbook.Worksheets(1).Activate ThisWorkbook.Worksheets(1).Range("A1").Select End Sub HTH, Barb Reinhardt "Elise148" wrote: I posted something yesterday and the suggestions I got were good, but they did not work. What I want to do is everytime a workbook is opened, have it be opened to a certain place...A1 of the first sheet. I am not the one that will be using this spreadsheet, I'm just designing it, and I know that the person using it will not know to save it in A1 of the first sheet before closing it...how would I go about doing this...go about programming it into VBA? Thanks... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook Opening in Certain Place
Hi,
The replies you got from your previous post will work, have another look. http://www.microsoft.com/office/comm...2-c22e3576ebec "Elise148" wrote: I posted something yesterday and the suggestions I got were good, but they did not work. What I want to do is everytime a workbook is opened, have it be opened to a certain place...A1 of the first sheet. I am not the one that will be using this spreadsheet, I'm just designing it, and I know that the person using it will not know to save it in A1 of the first sheet before closing it...how would I go about doing this...go about programming it into VBA? Thanks... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook Opening in Certain Place
What is "ThisWorkbook" code?
"Barb Reinhardt" wrote: Try putting this code into the "ThisWorkbook" code Private Sub Workbook_Open() ThisWorkbook.Worksheets(1).Activate ThisWorkbook.Worksheets(1).Range("A1").Select End Sub HTH, Barb Reinhardt "Elise148" wrote: I posted something yesterday and the suggestions I got were good, but they did not work. What I want to do is everytime a workbook is opened, have it be opened to a certain place...A1 of the first sheet. I am not the one that will be using this spreadsheet, I'm just designing it, and I know that the person using it will not know to save it in A1 of the first sheet before closing it...how would I go about doing this...go about programming it into VBA? Thanks... |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook Opening in Certain Place
I tried those again...and I must be entering them in the wrong place. Where
do I enter them? "Mike H" wrote: Hi, The replies you got from your previous post will work, have another look. http://www.microsoft.com/office/comm...2-c22e3576ebec "Elise148" wrote: I posted something yesterday and the suggestions I got were good, but they did not work. What I want to do is everytime a workbook is opened, have it be opened to a certain place...A1 of the first sheet. I am not the one that will be using this spreadsheet, I'm just designing it, and I know that the person using it will not know to save it in A1 of the first sheet before closing it...how would I go about doing this...go about programming it into VBA? Thanks... |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook Opening in Certain Place
Hi Elise
Paste the following code into the ThisWorkBook module of your workbook Private Sub Workbook_Open() ThisWorkbook.Sheets("Sheet1").Select Range("A1").Activate End Sub Press Alt + F11 to open the Visual Basic Editor Ctrl + R to ensure the Project Explorer pane is visible. Double click on this workbook, and paste the code into the large white pane. Alt + F11 again to return to Excel and Save the file. Next time you open you will find the cursor located in A1 of Sheet1, regardless of where it was at the point of saving. -- Regards Roger Govier "Elise148" wrote in message ... I posted something yesterday and the suggestions I got were good, but they did not work. What I want to do is everytime a workbook is opened, have it be opened to a certain place...A1 of the first sheet. I am not the one that will be using this spreadsheet, I'm just designing it, and I know that the person using it will not know to save it in A1 of the first sheet before closing it...how would I go about doing this...go about programming it into VBA? Thanks... |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook Opening in Certain Place
Alt+F11 to open VB editor
On the right hand side select workbook from the dropdown and put then in there. select the Open event on the other dropdown and put it in there. Mike "Elise148" wrote: I tried those again...and I must be entering them in the wrong place. Where do I enter them? "Mike H" wrote: Hi, The replies you got from your previous post will work, have another look. http://www.microsoft.com/office/comm...2-c22e3576ebec "Elise148" wrote: I posted something yesterday and the suggestions I got were good, but they did not work. What I want to do is everytime a workbook is opened, have it be opened to a certain place...A1 of the first sheet. I am not the one that will be using this spreadsheet, I'm just designing it, and I know that the person using it will not know to save it in A1 of the first sheet before closing it...how would I go about doing this...go about programming it into VBA? Thanks... |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook Opening in Certain Place
Roger, that will work as long as she doesn't change the worksheet name of
Sheet1 to something else. "Roger Govier" wrote: Hi Elise Paste the following code into the ThisWorkBook module of your workbook Private Sub Workbook_Open() ThisWorkbook.Sheets("Sheet1").Select Range("A1").Activate End Sub Press Alt + F11 to open the Visual Basic Editor Ctrl + R to ensure the Project Explorer pane is visible. Double click on this workbook, and paste the code into the large white pane. Alt + F11 again to return to Excel and Save the file. Next time you open you will find the cursor located in A1 of Sheet1, regardless of where it was at the point of saving. -- Regards Roger Govier "Elise148" wrote in message ... I posted something yesterday and the suggestions I got were good, but they did not work. What I want to do is everytime a workbook is opened, have it be opened to a certain place...A1 of the first sheet. I am not the one that will be using this spreadsheet, I'm just designing it, and I know that the person using it will not know to save it in A1 of the first sheet before closing it...how would I go about doing this...go about programming it into VBA? Thanks... |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook Opening in Certain Place
Quite correct Barb.
Your code is better as it will work in all circumstances. -- Regards Roger Govier "Barb Reinhardt" wrote in message ... Roger, that will work as long as she doesn't change the worksheet name of Sheet1 to something else. "Roger Govier" wrote: Hi Elise Paste the following code into the ThisWorkBook module of your workbook Private Sub Workbook_Open() ThisWorkbook.Sheets("Sheet1").Select Range("A1").Activate End Sub Press Alt + F11 to open the Visual Basic Editor Ctrl + R to ensure the Project Explorer pane is visible. Double click on this workbook, and paste the code into the large white pane. Alt + F11 again to return to Excel and Save the file. Next time you open you will find the cursor located in A1 of Sheet1, regardless of where it was at the point of saving. -- Regards Roger Govier "Elise148" wrote in message ... I posted something yesterday and the suggestions I got were good, but they did not work. What I want to do is everytime a workbook is opened, have it be opened to a certain place...A1 of the first sheet. I am not the one that will be using this spreadsheet, I'm just designing it, and I know that the person using it will not know to save it in A1 of the first sheet before closing it...how would I go about doing this...go about programming it into VBA? Thanks... |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Workbook Opening in Certain Place
Thanks everyone! I got it...
"Elise148" wrote: I posted something yesterday and the suggestions I got were good, but they did not work. What I want to do is everytime a workbook is opened, have it be opened to a certain place...A1 of the first sheet. I am not the one that will be using this spreadsheet, I'm just designing it, and I know that the person using it will not know to save it in A1 of the first sheet before closing it...how would I go about doing this...go about programming it into VBA? Thanks... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening Workbook at Certain Place | Excel Discussion (Misc queries) | |||
| 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) | |||
| Keeping cursor in same place on all worksheets in a workbook | Excel Worksheet Functions | |||
Linear Mode
