software

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 quot;home pagequot; for the work book

Thanks--
benson68
------------------------------------------------------------------------
benson68's Profile: www.excelforum.com/member.php...oamp;userid=30347
View this thread: www.excelforum.com/showthread...hreadid=500058
I think this should work for you -Code:
--------------------
Private Sub Workbook_Open()
Sheets(quot;Sheet1quot;).Activate
Range(quot;A1quot;).Select
End Sub

--------------------Just paste it into the 'This workbook' section in VB.--
mevetts------------------------------------------------------------------------
mevetts's Profile: www.excelforum.com/member.php...oamp;userid=29130
View this thread: www.excelforum.com/showthread...hreadid=500058
Excellent

Works a like a dream

Thank You--
benson68
------------------------------------------------------------------------
benson68's Profile: www.excelforum.com/member.php...oamp;userid=30347
View this thread: www.excelforum.com/showthread...hreadid=500058Thanks for the feedback.--
mevetts------------------------------------------------------------------------
mevetts's Profile: www.excelforum.com/member.php...oamp;userid=29130
View this thread: www.excelforum.com/showthread...hreadid=500058