Aways open workbook on sheet 1 ???

B

benson68

Hi

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

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

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

Thank
 
M

mevetts

I think this should work for you -


Code:
--------------------
Private Sub Workbook_Open()
Sheets("Sheet1").Activate
Range("A1").Select
End Sub
 
Top