Excel file query

  frenchman96 10:59 14 Apr 2009

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 2009

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 2009

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.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

See mcbess's iconic style animated for Mercedes-Benz

iPhone X news: Release date, price, new features & specs

Black Friday 2017 : date, sites participants & bonnes affaires