M
Mike
I have 20 sheets in an excel document. Is there any way
to have the document always open on a specified sheet.
Thanks.
to have the document always open on a specified sheet.
Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
A very often asked question. Did you try the archives or a google search
using Ron's addin?
http://www.rondebruin.nl/
using Ron's addin?
http://www.rondebruin.nl/
M
Mike
I am on a government computer and can not install
anything. Any other ideas??
anything. Any other ideas??
N
Norman Harker
Hi Mike!
Here's a routine that I use:
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
It does more than you ask but it sets up the workbook.
I have a cell named StartPoint that will be the top left cell when the
workbook is opened.
--
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.
Here's a routine that I use:
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
It does more than you ask but it sets up the workbook.
I have a cell named StartPoint that will be the top left cell when the
workbook is opened.
--
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.
M
Mike Ferris
Norman, I appreciate the help, but this is way above my
head. I do not even know where to put that code at.
Thanks for your help though.
Mike Ferris
head. I do not even know where to put that code at.
Thanks for your help though.
Mike Ferris
N
Norman Harker
Hi Mike!
Print out these instructions (just to make it easier).
Select the subroutine that I posted
With the workbook open
Right click on the sheet tab > View Code
Select and expand the workbook in the top left window (the project
Explorer
Double click on This Workbook
Point and click in the large window on the right
Right Click > Paste
File > Save
Exit the Visual Basic screen by clicking the X button
Select the cell on the sheet which you want top left
Click on the name box to the left of the Formula bar
Type StartPoint
Press Enter
Select another cell on another sheet
File > Save
File > Close
Now re-open the file and (hopefully) you will start the New Year with
a working subroutine that does what you want.
Happy New Year
--
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.
Print out these instructions (just to make it easier).
Select the subroutine that I posted
With the workbook open
Right click on the sheet tab > View Code
Select and expand the workbook in the top left window (the project
Explorer
Double click on This Workbook
Point and click in the large window on the right
Right Click > Paste
File > Save
Exit the Visual Basic screen by clicking the X button
Select the cell on the sheet which you want top left
Click on the name box to the left of the Formula bar
Type StartPoint
Press Enter
Select another cell on another sheet
File > Save
File > Close
Now re-open the file and (hopefully) you will start the New Year with
a working subroutine that does what you want.
Happy New Year
--
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.