Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



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

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 04-06-2009
Member
 
Join Date: Apr 2009
Posts: 97
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
Member
 
Join Date: May 2008
Posts: 4,829
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
Member
 
Join Date: Apr 2008
Posts: 4,086
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
Member
 
Join Date: Jan 2008
Posts: 3,751
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
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!!
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How can i go to Specific tab in Excel on Windows Vista"
Thread Thread Starter Forum Replies Last Post
Is there a Excel add-in to open specific number of file Ichabod MS Office Support 2 27-01-2012 08:06 PM
Formula to count the occurrences of specific letter in excel Mithun Seth Windows Software 5 09-01-2010 01:03 PM
Excel Password Issue on Windows Vista Sori Windows Software 4 04-01-2010 01:44 PM
How to create excel graph data for a month in Windows Vista AK_Chopra Windows Software 2 04-06-2009 08:58 PM
Uninstall Microsoft Excel 97 from Windows Vista dj928 Operating Systems 6 16-03-2009 11:48 AM


All times are GMT +5.5. The time now is 06:25 AM.