Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Startup on a specific worksheet
Is there any way to always start on a specific worksheet no matter in which
one you saved last time? Please help!! Thnx |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Startup on a specific worksheet
enter something like this in a workbook "open" macro
Worksheets("sheet3").Select Range("A19").Select to get there.......... right click onto the small excel emblem to the left of the word "file" in the menu toolbar select "view code" select "workbook" in the left dropdown arrow paste the above lines between the Private Sub Workbook_Open() and End Sub lines of course you can change the sheet name and cell to suit -- Greetings from New Zealand "Jens Palacios Neffke" wrote in message ... Is there any way to always start on a specific worksheet no matter in which one you saved last time? Please help!! Thnx |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Startup on a specific worksheet
Thanks a lot, it worked alright
"Bill Kuunders" wrote: enter something like this in a workbook "open" macro Worksheets("sheet3").Select Range("A19").Select to get there.......... right click onto the small excel emblem to the left of the word "file" in the menu toolbar select "view code" select "workbook" in the left dropdown arrow paste the above lines between the Private Sub Workbook_Open() and End Sub lines of course you can change the sheet name and cell to suit -- Greetings from New Zealand "Jens Palacios Neffke" wrote in message ... Is there any way to always start on a specific worksheet no matter in which one you saved last time? Please help!! Thnx |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Startup on a specific worksheet
On Apr 11, 3:38 pm, Jens Palacios Neffke
wrote: Is there any way to always start on a specific worksheet no matter in which one you saved last time? Please help!! Thnx Microsoft Excel has a startup directory that you can place these files 1) BOOK.XLT and SHEET.XLT are customizable blank workbook and worksheet templates for File New and Insert Worksheet operations, respectively 2) Non-template Excel files *.XLS, *.XLA will be preloaded each time Excel starts. Depending on your version of Excel, the default location of the startup directory should be located at: C:\Program Files\Microsoft Office\OFFICE\XLSTART\ C:\Program Files\Microsoft Office\OFFICE11\XLSTART\ You can also specify a different specific directory using Tools Options General "At startup, open all files in:". |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Startup on a specific worksheet
On Apr 11, 3:38 pm, Jens Palacios Neffke
wrote: Is there any way to always start on a specific worksheet no matter in which one you saved last time? Please help!! Thnx Microsoft Excel has a startup directory feature where these files: 1) Tempalte Excel files BOOK.XLT and SHEET.XLT will be used as blank templates when using File New and Insert Worksheet, respectively 2) Non-template Excel Files *.XLS, *.XLA will preload on each Excel startup The default location of the startup directory depends on the version of Excel. Some examples a C:\Program Files\Microsoft Office\OFFICE\XLSTART C:\Program Files\Microsoft Office\OFFICE11\XLSTART To specify another directory, use Tools Options General "At startup, open all files in:" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i get excel to stop opening a blank worksheet @ startup? | Excel Discussion (Misc queries) | |||
at startup, i would like a specific workbook to open. | Setting up and Configuration of Excel | |||
How do I set a worksheet to be the default at startup? | Setting up and Configuration of Excel | |||
Run a Macro on Startup for Specific Spreadsheet | Excel Worksheet Functions | |||
How do I make excel startup in a specific sheet? | Excel Worksheet Functions |