Excel file query

  frenchman96 10:59 14 Apr 09
Locked

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.

Surface Pro 5 News - release date, UK price, features, specs

Gear VR vs. Daydream: Which delivers the best VR experience?

Best Mac antivirus 2017