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 |
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. |
All times are GMT +1. The time now is 07:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com