With your desired workbook open, right click on the small spreadsheet
icon to the left of the "File" menu item at the top of the window.
Click 'View Code'. This opens the VBA editor to the workbook project.
Paste this code into the blank pane on the right hand side:



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

Change "Title_Sheet" to the name of the desired sheet to open to....

press ALT + Q to close the editor and return to your workbook. Save
your file (have a different sheet active). Close and reopen. It
should open to your 'Title_Sheet'.

Good Luck.

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=469106