R
Rebel
I want excel to open at the top of my spreadsheet instead of the bottom
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.
G
Gord Dibben
Worksheet view in active window will be whereever it was when you last saved
the workbook.
You could add VBA Event code to show a particular view when that sheet is
activated or when the workbook is opened.
Example of sheet activation event code.
Private Sub Worksheet_Activate()
Application.Goto Range("A1"), Scroll:=True
End Sub
Right-click on the sheet tab and "View Code".
Copy/paste the code into that module.
Alt + q to return to Excel window.
Gord Dibben MS Excel MVP
the workbook.
You could add VBA Event code to show a particular view when that sheet is
activated or when the workbook is opened.
Example of sheet activation event code.
Private Sub Worksheet_Activate()
Application.Goto Range("A1"), Scroll:=True
End Sub
Right-click on the sheet tab and "View Code".
Copy/paste the code into that module.
Alt + q to return to Excel window.
Gord Dibben MS Excel MVP
S
Sheeloo
It opens at the position it was last saved.
If you want it to go to A1 everytime you open the worksheet...
Right-click on the sheetname at the bottom, choose View Code and paste the
following;
Private Sub Worksheet_Activate()
Range("A1").Activate
End Sub
Close the editor
If you want it to go to A1 everytime you open the worksheet...
Right-click on the sheetname at the bottom, choose View Code and paste the
following;
Private Sub Worksheet_Activate()
Range("A1").Activate
End Sub
Close the editor
R
Rebel
Neither code is working....
Sheeloo said:It opens at the position it was last saved.
If you want it to go to A1 everytime you open the worksheet...
Right-click on the sheetname at the bottom, choose View Code and paste the
following;
Private Sub Worksheet_Activate()
Range("A1").Activate
End Sub
Close the editor
S
Sheeloo
Download http://wikisend.com/download/589412/GoTo A1.xls
and compare with what you are doing..
To test
select any cell in sheet1...
go to sheet2 or sheet3
click on sheet1 to come back to it
It should open at A1
and compare with what you are doing..
To test
select any cell in sheet1...
go to sheet2 or sheet3
click on sheet1 to come back to it
It should open at A1
R
Rebel
No......I dont know....well I can just tell my client to save it at the
top....so it will re-open there for her.....
top....so it will re-open there for her.....
R
Rebel
Nope.....not working...I will just tell her to save it at the top.
J
Jacob Skaria
Maybe the security settings within Tools>Security is set to high..and so
macros are disabled..
If this post helps click Yes
macros are disabled..
If this post helps click Yes
S
Sheeloo
Ok.
btw macros must be enabled for the code to work.
btw macros must be enabled for the code to work.
R
Rebel
lol it occurred right before I read it that the macros were disabled!!
You all ROCK...thanks sooooo much!
You all ROCK...thanks sooooo much!