How do I create "push buttons" in Excel?

[Guest]

I am trying to create push buttons in Excel. (Hyperlinks, maybe?) It is a
button that can be pushed to direct the user to a different worksheet in the
same file.

 

[Guest]

Use the HYPERLINK function to place a hyperlink in the file.

If you want a button instead of a hyperlink, you can create a macro which
you then assign to a button.

Dave

 

[Guest]

Use the HYPERLINK function to place a hyperlink in the file.

If you want a button instead of a hyperlink, you can create a macro which
you then assign to a button.

Dave

 

[Gord Dibben]

From the Drawing Toolbar select any shape you want.

I will select the rectangle tool.

Draw a rectangle on your sheet and right-click onit and "Hyperlink".

Choose from "place in this document" and OK.

Right-click again and "Add text" to the shape.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

From the Drawing Toolbar select any shape you want.

I will select the rectangle tool.

Draw a rectangle on your sheet and right-click onit and "Hyperlink".

Choose from "place in this document" and OK.

Right-click again and "Add text" to the shape.


Gord Dibben MS Excel MVP