Excel - Button to go to a certain sheet

excel excel-2007
CustomX picture CustomX · Aug 22, 2012 · Viewed 197.8k times · Source

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! :)

Answer

user857521 picture user857521 · Aug 22, 2012

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

enter image description here

enter image description here

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.

Related questions

Append same text to every cell in a column in Excel

How can I append text to every cell in a column in Excel? I need to add a comma (",") to the end. Example: [email protected] turns into [email protected], Data Sample: [email protected] satishmm_2sptc@…

Read More
How to do a "Save As" in vba code, saving my current Excel workbook with datestamp?

I have an Excel Workbook that on form button click I want to save a copy of the workbook with the filename being the current date. I keep trying the the following ActiveWorkbook.SaveAs ("\\filePath\FormFlow To MSExcel\" & Left(…

Read More
Closing Excel Application using VBA

I have used the following without success. The active workbook closes, indeed, but the excel window remains open. Application.ActiveWindow.Close SaveChanges:=False ActiveWorkbook.Close SaveChanges:=False Which is the command that terminates the application? EDIT To say a little …

Read More