Wanting code to refer back to specific sheet

  oo7juk 11:34 14 Nov 07


I have a workbook containing 7 sheets. Sheet3 of my workbook contains command buttons which open other sheets within the wb. If I am viewing Sheet4 and then save doc when I go to open doc again it opens at Sheet4. I would like it to always open on Sheet3.


  Noldi 12:00 14 Nov 07

click here
Vog sorted something simular for me.


  oo7juk 12:29 14 Nov 07

Thanks Noldi,

Unfortunately it created an error 'ambigious name' I also have another code running on this book with the Sub Open option, maybe the conflict lies there.

  VoG II 12:46 14 Nov 07

Just add this line

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

(change the sheet name to suit)

before the End Sub of your existing code.

  Noldi 17:28 14 Nov 07

The worksheet brackets is the sheet name you want =worksheets("Sheet3"). or change to what you have named the sheet.

As VOG writes in the original post "change Intro and A1 to what you want"


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…