Excel - Button to go to a certain sheet

Question

I m trying to create a button to take me to my Index sheet  I know how to do it using a macro or a hyperlink  but my users aren t  smart  users and will be calling me all day if I use macros   Does anyone know how I could solve this  besides using a hyperlink  I was thinking of a button with a hyperlink  but haven t found a way to do it   Thank you

User · Answer

You have to add Button to excel sheet say sheet1  from which you can go to another sheet say sheet2    Button can be added from Developer tab in excel  If developer tab is not there follow below steps to enable   GOTO file -  options -  Customize Ribbon -  enable checkbox of developer on right panel -  Done   To Add button  -  Developer Tab -  Insert -  choose first item button -  choose location of button-  Done   To give name for button  -  Right click on button -  edit text   To add code for going to sheet2  -  Right click on button -  Assign Macro -  New -   microsoft visual basic will open to code for button  -  paste below code  Worksheets  Sheet2   Visible   True Worksheets  Sheet2   Activate   Save the file using  Excel Macro Enable Template   xltm   By which the code is appended with excel sheet

User · Answer

Any reason they can t just click on the tab for your sheet when they want it

User · Answer

You don t need to create a button  The facility exists by default   Just right click on the arrow buttons on the bottom left hand corner of the Excel window  These are the arrow buttons which if you left click move left or right one worksheet   If you right-click on these arrows Excel will pop up a dialogue with a list of worksheets from which you can click to set your chosen sheet active

User · Answer

Alternately  if you are using a Macro Enabled workbook   Add any control at all from the Developer -  Insert  Probably a button   When it asks what Macro to assign  choose New  For the code for the generated module enter something like   Thisworkbook Sheets  Sheet Name   Activate   However  if you are not using Macros in your work book  Ooo s approach is definitely surperior as hyperlinks will work with no need to trust the document

User · Answer

In Excel 2007  goto Insert Shape and pick a shape  Colour it and enter whatever text you want  Then right click on the shape and insert a hyperlink      A few tips with shapes    If you want to easily position the shape with cells  hold down Alt when you move the shape and it will lock to the cell  If you don t want the shape to move or resize with rows columns  right click the shape  select size and properties and choose the setting which works best

[excel] Excel - Button to go to a certain sheet

Examples related to excel

Examples related to excel-2007