Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
wud like 2 open the w.book of 12 sheets with my desired sheet?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
wud like 2 open the w.book of 12 sheets with my desired sheet?
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" 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto "copy and paste" individual cells from various sheets into one sheet ?? | Excel Discussion (Misc queries) | |||
Autofilter Lists across Multiple Sheets, Maintain Correct Referenc | Excel Worksheet Functions | |||
calculate totals of 5 sheets on to 6th sheet. | Excel Worksheet Functions | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |