Excel - button to go to a specific sheet

Question

I am trying to create a button to take me to my index sheet. I know how to do this using a macro or a hyperlink, but my users are not smart users and will call me all day if I use macros.

Does anyone know how I can solve this other than using a hyperlink? I thought of a button with a hyperlink, but did not find a way to do this!

Thanks!:)

Answer 1

In Excel 2007, go to Insert / Shape and select a shape. Color it and enter any text you want. Then right click on the shape and paste the hyperlink

A few tips with figures.

If you want to easily place a shape with cells, press and hold Alt when you move the shape, and it will be locked for the cell. If you do not want the shape to be moved or resized using rows / columns, right-click the shape, select the size and properties, and select the setting that works best.

Answer 2

Alternatively, if you are using a book with macro support:

Add any control from the Developer → Insert application (possibly a)

When he asks about the purpose of the macro, select Create. For the code for the generated module, enter something like:

Thisworkbook.Sheets("Sheet Name").Activate 

However, if you are not using macros in your workbook. The Ooo approach is definitely more complex, since hyperlinks will work without having to trust the document.

Answer 3

You need to add a button for the excel sheet (say sheet1 ), from which you can go to another sheet (say sheet2 ).

The button can be added from the Developer tab in excel. If the developer tab is missing, follow these steps to enable it.

GOTO file -> options -> Configure ribbon -> enable the developer flag in the right pane -> Finish.

Add Button: -

developer tab → Insert → select the button of the first element → select the location of the button-> Finish.

To specify a button name: -

Right-click on the button → edit the text.

To add code to go to sheet2: -

Right click -> Assign Macro -> New -> (Microsoft Visual Basic opens for the code for the button) -> paste the code below

 Worksheets("Sheet2").Visible = True Worksheets("Sheet2").Activate 

Save the file using the "Excel Macro Resolution Template (*. Xltm)", with which the code is added using an excel sheet.

Answer 4

You do not need to create a button. The object exists by default.

Just right-click on the arrow buttons in the lower left corner of the Excel window. These are arrow buttons, which, if you left-click, move one worksheet left or right.

If you right-click on these arrows, Excel will open a dialog with a list of sheets from which you can click to customize the selected sheet.

Answer 5

For some reason, they can't just click the tab for their sheet when they want?