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
|