Excel file query

  frenchman96 10:59 14 Apr 09

Hi Guys

Every time I open a certain Ecel file which contains my tel numbers, the bottom slider is at extreme right and the scroll arrow does not move it so I c/on slider and drag.

The when I close and open, same thing, it like it is defaulting in that position.

Not important enough to start a war but annoying, any ideas please.

  VoG II 11:16 14 Apr 09

Try this: right click the Excel logo just to the left of File on the menu bar, select View Code and paste in

Private Sub Workbook_Open()
Application.Goto reference:=Sheets("Sheet1").Range("A1"), scroll:=True
End Sub

Change Sheet1 to the name of your sheet.

Then Save, close and re-open the file.

  frenchman96 13:14 14 Apr 09

Hi Vog

I did a copy/paste/blank sheet/save and all is well thank you.

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…