Excel

  Noldi 13:18 12 May 2006
Locked

Could somebody help me with this problem.

I want to open a Excel workbook in a set cell no mater which cell is active when its saved and closed. I have no problem doing this from another Excel sheet via a hyperlink but not from a desktop icon.
(eg adding this on to the target .xls#'Assembly & Logistics'!J8)


Noldi

  VoG II 13:26 12 May 2006

ALT + F11 to open the Visual Basic Editor, Insert > Module. Paste in tyhe following:

Sub Auto_Open()
Application.Goto reference:=Worksheets("Intro").Range("A1"), scroll:=True
End Sub

(change Intro and A1 to what you want.

Close the Visual Basic Editor.

  Noldi 14:24 12 May 2006

Cheers VOG

First bracket is sheet name second is cell ref.

Thanks again Nodi

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

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

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

Comment créer, modifier et réinitialiser un compte Apple ?