Aways open workbook on sheet 1 ???
 

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


--
benson68
------------------------------------------------------------------------
benson68's Profile: http://www.excelforum.com/member.php...o&userid=30347
View this thread: http://www.excelforum.com/showthread...hreadid=500058

Aways open workbook on sheet 1 ???
 

I think this should work for you -


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

--------------------


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


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=500058

Aways open workbook on sheet 1 ???
 

Excellent

Works a like a dream

Thank You


--
benson68
------------------------------------------------------------------------
benson68's Profile: http://www.excelforum.com/member.php...o&userid=30347
View this thread: http://www.excelforum.com/showthread...hreadid=500058

Aways open workbook on sheet 1 ???
 

:)

Thanks for the feedback.


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=500058