Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VB needed to ensure Workbook opens on Menu sheet !

Status
Not open for further replies.

liamothelegend

Technical User
Oct 23, 2003
2
GB
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.
 
Use,

Sub Auto_Open
Sheets("Menu").Activate
End Sub

A.C.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top