Windows Live Messenger: How can i go to Specific tab in Excel on Windows Vista

How can i go to Specific tab in Excel on Windows Vista
I'm running Windows Vista along with Microsoft Office 2003 on my pc. I'm having a 309 sheets on my pc. So. i would like to know that how do i create a button on each sheet, in order to bring back to sheet 1 when i try to click on it. Is it possible for me to do so? Kindly provide me the solution for the above issue. Any kind of help on teh above issue would eb appreciated.
Reply With Quote
#2
Old 04-06-2009
Macarenas's Avatar
Macarenas Macarenas is offline
Member

Join Date: May 2008
Posts: 4,801
Re: How can i go to Specific tab in Excel on Windows Vista
For tha you need to right-click the sheet navigation buttons which you can see it on the left of the sheet tabs. If there are more worksheets than can comfortably fit in the list, then one of the options is "More Sheets." Select that option, and you end up with a dialog box that lists all the worksheets and you can make your selection.
Reply With Quote
#3
Old 04-06-2009
ThoMas321's Avatar
ThoMas321 ThoMas321 is offline
Member

Join Date: Apr 2008
Posts: 4,067
Re: How can i go to Specific tab in Excel on Windows Vista
You need to set the Value property of the multipage on your excel sheet. You need to know that the page number are zero based. Following is the code, might help you out.

Quote:
Private Sub UserForm_Initialize()

MultiPage1.Value = 1 ' tab 2

End Sub
Reply With Quote
#4
Old 04-06-2009
Sam.D's Avatar
Sam.D Sam.D is offline
Member

Join Date: Jan 2008
Posts: 3,734
Re: How can i go to Specific tab in Excel on Windows Vista
You can also try out the following steps.

1. You need to Press F5 key. Then Excel will displays a dialog box on your desktop screen.
2. Then on the Reference box, you need to enter any sheet number, let say for example Sheet83!A1. ( Try to replace "Sheet83" with the name of the worksheet that you want to jump to.)
3. And last you need to click on OK tab.
Reply With Quote
#5
Old 02-03-2011
schweenr schweenr is offline
Member

Join Date: Mar 2011
Posts: 1
Re: How can i go to Specific tab in Excel on Windows Vista
Sam.D is correct, except for when you're naming your tabs with more than one word. For example, if you're tab is named "Worksheet Number One", press F5 and type in 'Worksheet Number One'!A1. One-word tab names don't require an apostrophe ('), but two word tabs must have them!!