VB needed to ensure Workbook opens on Menu sheet !

[liamothelegend]

Hi this is probably a simple one for most of you. I am on just learning how to programme VB in Excel and would appreciate some help.
I have created a Menu sheet with a lot of dynamic links and would like to ensure that when the work book is opened this menu sheet always opens first rather than where the last sheet a user saves it in.
Thanks in advance.

 

[SkipVought]

Hi,

Use the Workbook_Open event in the Workbook Object.

Worksheets("Menu").Activate

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[acron]

Use,

Sub Autpen
Sheets("Menu&quot.Activate
End Sub

A.C.

 

[liamothelegend]

Jobs a good un
Good work fellas !!!
Thanks
Liam