default page location
default page location
(OP)
Not exactly an engineering question, but is there any way to set a view of a spreadsheet so that when it opens it's scrolled to the right, not to the left?
I'm using someone else's sheet and there's some useless stuff on the left and some useful stuff to the right and either I have to scroll over every time I open it, or else zoom out (it'll remember the zoom level next time but then I'm looking at smaller numbers).
Hg
I'm using someone else's sheet and there's some useless stuff on the left and some useful stuff to the right and either I have to scroll over every time I open it, or else zoom out (it'll remember the zoom level next time but then I'm looking at smaller numbers).
Hg
Eng-Tips policies: FAQ731-376





RE: default page location
RE: default page location
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
Steam Engine enthusiasts: www.essexsteam.co.uk
RE: default page location
===============================
Sub Auto_Open()
Workbooks("your spreadsheet name.xls").Worksheets("the sheet you want to see").Activate
Range("cell where you want the cursor").Select
End Sub