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

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

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

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:".

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:"