Another beginner question, opening files with a certain sheet on top.

  • Thread starter Thread starter Steve Barker
  • Start date Start date
S

Steve Barker

When I open a file, I want it to always have a certain worksheet on top.
Regardless of what sheet was on top when last saved. I've been searching
the help files, and I'm sorry to ask such basic questions, but I'm a
computer geek, not an excel wizard. <G>.


TEA!!

--
Steve Barker
Stilwell, Kansas
UP (MoPac) Coffeyville Sub MP 308
Nikon Coolpix 995
PSP 8.00

=========
 
You would need a macro in that file

Private Sub Workbook_Open()
Worksheets("Sheet1").Activate
End Sub

replace Sheet1 with the sheet name in question,
right click the excel icon to the left of the file menu and select view code
and past in the above
or press Alt + F11, double click ThisWorkbook in the project pane to the
left and paste in the above
 
Hi Steve!

Extending Peo's suggestion:

Private Sub Workbook_Open()
Application.Goto
Reference:=Worksheets("Sheet10").Range("A100"),scroll:=True
End Sub

Or even:

Private Sub Workbook_Open()
Application.ScreenUpdating = False
Dim n As Integer
For n = 1 To Worksheets.Count
Worksheets(n).Select
Application.Goto Reference:=Range("a1"), Scroll:=True
Next n
Application.Goto Reference:="StartPoint", Scroll:=True
Application.ScreenUpdating = True
End Sub

In this case I reset all sheets to open at a1 and then put the cell
named startpoint at the top left of the screen.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
OK! Thanks!

--
Steve Barker
Stilwell, Kansas
UP (MoPac) Coffeyville Sub MP 308
Nikon Coolpix 995
PSP 8.00

=========
 
Back
Top