Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening a tab automatically in a file
Hello Excel(lent) users,
I have made a file with a number of tabs. One of those tabs is called Menu. In that tab I have made links to different other tabs. Now I want the file to open always with that tab, regardless of how it has been saved the previous time. Is there an easy way to do this?? Thanks kindly!! -- ** Fool on the hill ** |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening a tab automatically in a file
You can implement a workbook_open() macro like so
Private Sub Workbook_Open() Worksheets("Menu").Activate End Sub To paste this in, right click on the Excel Icon for the workbook (NOT the application one) and select view code... Paste it here, save and close workbook, now every time it open it will go to the Menu worksheet -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Jaydubs" wrote in message ... Hello Excel(lent) users, I have made a file with a number of tabs. One of those tabs is called Menu. In that tab I have made links to different other tabs. Now I want the file to open always with that tab, regardless of how it has been saved the previous time. Is there an easy way to do this?? Thanks kindly!! -- ** Fool on the hill ** |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening a tab automatically in a file
Hello Nick,
Thanx for the reply, but I don't understand what you mean with the Excel Icon for the workbook, where can I find it (as you said it is not the icon in the explorer)?? Thanx -- ** Fool on the hill ** "Nick Hodge" wrote: You can implement a workbook_open() macro like so Private Sub Workbook_Open() Worksheets("Menu").Activate End Sub To paste this in, right click on the Excel Icon for the workbook (NOT the application one) and select view code... Paste it here, save and close workbook, now every time it open it will go to the Menu worksheet -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Jaydubs" wrote in message ... Hello Excel(lent) users, I have made a file with a number of tabs. One of those tabs is called Menu. In that tab I have made links to different other tabs. Now I want the file to open always with that tab, regardless of how it has been saved the previous time. Is there an easy way to do this?? Thanks kindly!! -- ** Fool on the hill ** |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening a tab automatically in a file
Hi Jay,
Try: '============= Private Sub Workbook_Open() Me.Sheets("Menu").Select End Sub '<<============= This is workbook event code and should be pasted into the workbook's ThisWorkbook module *not* a standard module or a sheet module: Right-click the Excel icon on the worksheet (or the icon to the left of the File menu if your workbook is maximised) Select 'View Code' from the menu and paste the code. Alt-F11 to return to Excel. If you are not familiar with macros, you may wish to visit David McRitchie's 'Getting Started With Macros And User Defined Functions' at: http://www.mvps.org/dmcritchie/excel/getstarted.htm --- Regards, Norman "Jaydubs" wrote in message ... Hello Excel(lent) users, I have made a file with a number of tabs. One of those tabs is called Menu. In that tab I have made links to different other tabs. Now I want the file to open always with that tab, regardless of how it has been saved the previous time. Is there an easy way to do this?? Thanks kindly!! -- ** Fool on the hill ** |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening a tab automatically in a file
Hi Nick,
Apologies, I did not see your response when I replied! --- Regards, Norman |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening a tab automatically in a file
Nick, Norman,
Both, thanx for your help, exactly what I was looking for !! -- ** Fool on the hill ** "Norman Jones" wrote: Hi Jay, Try: '============= Private Sub Workbook_Open() Me.Sheets("Menu").Select End Sub '<<============= This is workbook event code and should be pasted into the workbook's ThisWorkbook module *not* a standard module or a sheet module: Right-click the Excel icon on the worksheet (or the icon to the left of the File menu if your workbook is maximised) Select 'View Code' from the menu and paste the code. Alt-F11 to return to Excel. If you are not familiar with macros, you may wish to visit David McRitchie's 'Getting Started With Macros And User Defined Functions' at: http://www.mvps.org/dmcritchie/excel/getstarted.htm --- Regards, Norman "Jaydubs" wrote in message ... Hello Excel(lent) users, I have made a file with a number of tabs. One of those tabs is called Menu. In that tab I have made links to different other tabs. Now I want the file to open always with that tab, regardless of how it has been saved the previous time. Is there an easy way to do this?? Thanks kindly!! -- ** Fool on the hill ** |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening a tab automatically in a file
Norman
No probs...you explanation of the implementation got the OP there, so a joint effort -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Norman Jones" wrote in message ... Hi Nick, Apologies, I did not see your response when I replied! --- Regards, Norman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel | |||
Opening a file and enabling macros automatically | Excel Discussion (Misc queries) | |||
Opening an Excel File | Excel Discussion (Misc queries) | |||
Automatically update from source when file opens | Excel Discussion (Misc queries) | |||
Trouble opening an Excel file that contains macros | Excel Worksheet Functions |