Return to certain tab each time workbook is opened

[warrima]

Hi,

I have an excel file on a share site which is accessed by several people. The first tab is set up as a home page which directs the person to the relevent part of the work book that they need. My problem is that as the person saves their updates it also saves the location of the workbook they were in. I want it to return to the " homepage" automatically each time it is opened. Thanks in advance.

[teylyn]

Hi, you could use a macro for the workbook before save event. When somebody attempts to save the workbook, the macro could navigate to A1 on your home page and only then save the workbook.

[warrima]

Thanks Teylyn,

How would i go about this. What would my macro code be. Thanks for the help.

[teylyn]

Hi,

alternatively, you could use the Workbook_Open event to navigate to the desired sheet when the workbook is opened.

Hit Alt-F11 to open the VB editor, then double click on the "This Workbook" entry on the left hand side. In the code panel enter

Private Sub Workbook_Open()
    Sheets("Sheet1").Activate
End Sub

Change the "Sheet1" bit to whatever your home page is called.

hth

[warrima]

Works a treat. Thanks a lot.

[teylyn]

Glad it works for you. Could you please mark the thread as solved?