View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jens Palacios Neffke[_2_] Jens Palacios Neffke[_2_] is offline
external usenet poster
 
Posts: 8
Default 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