Aways open workbook on sheet 1 ???

[benson68]

Hi

I have a multi-sheet workbook which performs various calculations on each sheet

Is it at all possible to make the work book allways open on sheet 1 even if the last save was on sheet 4 for example

Sheet 1 is like the "home page" for the work book

Thanks

[mevetts]

I think this should work for you -

Private Sub Workbook_Open()
Sheets("Sheet1").Activate
Range("A1").Select
End Sub

Just paste it into the 'This workbook' section in VB.

[benson68]

Excellent

Works a like a dream

Thank You

[mevetts]

Thanks for the feedback.