MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Opening Excel Workbook at first worksheet.

Posted by Gerald Marshall on November 01, 2001 1:24 PM

An Excel Workbook with several Worksheets.
The first sheet contains Hyperlinks to all the other worksheets.
is it possible to always open the workbook at the first worksheet irrespective of which worksheet was opened when file was saved ?


Posted by lenze on November 01, 2001 1:31 PM

It doesn't work even if I select all cell in every sheet and look (find) after the name of the other (linked) worksheet; it can't find any link.

Posted by bob umlas on November 01, 2001 1:59 PM

Include a workbook_open event which has
Private Sub Workbook_Open()
End Sub
--the above needs to be in the event handler for a workbook (Right-click eht excel logo to the left of the File menu, select View Code, enter the above)
use an Auto_Open:
Sub Auto_Open()
End Sub
--the above goes in a normal module

Posted by Gerald Marshall on November 01, 2001 10:44 PM

Hi Bob
Thanks very much for your help. Much Appreciated.