wud like 2 open the w.book of 12 sheets with my desired sheet?

[Shariq]

Hi Everybody!
I've created a book with various sheets in it, what I'd like to do is, that
whenever I open this book it should always show or open the sheet 1, which
works as a main menu for me coz I've put hyperlinks on it to the other sheets
in this book.
I'll be very grateful if somebody can help me with this.
Regards,
Shariq

[David McRitchie]

Hi Sharig,
You would need an event macro in ThisWorkbook

Right click on the logo to the left of the Excel menus, then View code
and enter the following coe there.l

Sub WorkBook_Open()
WorkSheets("Sheet1").Activate
End Sub

More information on event macros in
http://www.mvps.org/dmcritchie/excel/event.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Shariq" <Shariq@discussions.microsoft.com> wrote
> I've created a book with various sheets in it, what I'd like to do is, that
> whenever I open this book it should always show or open the sheet 1, which
> works as a main menu for me coz I've put hyperlinks on it to the other sheets
> in this book.