Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to I make sure that my workbook always opens with a desired sh
Hi!
I've got a problem. I want to make sure that everytime I open a workbook, to make it open always with the same page/sheet I want, because normally it will open the sheet you were working on last.(before you closed it). so please if someone can help me. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to I make sure that my workbook always opens with a desired sh
Let's say you sheetname is shariq. Put the following macro in ThisWorkBook
code: Private Sub Workbook_Open() Worksheets("shariq").Activate End Sub Whenever the workbook is opened, that sheet will be activated. -- Gary's Student "Shariq" wrote: Hi! I've got a problem. I want to make sure that everytime I open a workbook, to make it open always with the same page/sheet I want, because normally it will open the sheet you were working on last.(before you closed it). so please if someone can help me. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to I make sure that my workbook always opens with a desired sh
Use this macro code to select the desired sheet when opening
Private Sub Auto_Open() Sheets("The sheet name").Select End Sub Tony On Dec 20, 8:59 pm, Shariq wrote: Hi! I've got a problem. I want to make sure that everytime I open a workbook, to make it open always with the same page/sheet I want, because normally it will open the sheet you were working on last.(before you closed it). so please if someone can help me. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to I make sure that my workbook always opens with a desired sh
If you hit Ctrl + Home it will take you to the first cell in the worksheet
you are working on. If you save while there it will open to this spot. Same should work for any page you are on when you save. "Shariq" wrote: Hi! I've got a problem. I want to make sure that everytime I open a workbook, to make it open always with the same page/sheet I want, because normally it will open the sheet you were working on last.(before you closed it). so please if someone can help me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make multiple copies of a sheet in a new workbook | Excel Worksheet Functions | |||
How to I make sure that my workbook always opens with a desired sh | Excel Discussion (Misc queries) | |||
When opening an existing workbook, Excel opens but not the workbo. | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
Workbook opens twice | Excel Discussion (Misc queries) |