Wanting code to refer back to specific sheet

  oo7juk 11:34 14 Nov 2007


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 2007

click here
Vog sorted something simular for me.


  oo7juk 12:29 14 Nov 2007

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 2007

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 2007

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.

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 regarder des séries et talk-shows américains en France ?