Workbook

[agonysWeeper]

Hi Forum,

I have my book1 which has a 36sheets and sometimes I save it while I'm in sheet2 or any of those sheets, but problem is, I want this book to every time we open, its always focus on sheet1 (Sheet1 is the table of content) even we save it while in sheet36.

Can anyone help me here? thanks

 

[Peter_SSs]

Try this in the ThisWorkbook module of the relevant workbook

Private Sub Workbook_Open()
    Application.Goto Reference:=Sheets(1).Range("A1"), Scroll:=True
End Sub

 

[agonysWeeper]

Hi Peter,

Im not familiar with Macro, can you guide me. :]

 

[Peter_SSs]

1. Alt+F11 to open the VBA editor.

2. Locate your workbook name in the left hand pane and open it out with the '+' signs if necessary till you can see the items in the 'Microsoft Excel Objects' folder. You should see a list of your worksheets.

3. At the bottom of the worksheet list you should see an item called 'ThisWorkbook'. Double click it.

4. Copy the code I posted and paste it into the main right hand pane that opened at step 3.

5. Close the VBA window.

6. Save your workbook (preferably while you are not on the first sheet)

7. Close the workbook and re-open it.

 

[agonysWeeper]

Got it - thanks Mr Petter