ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I create "push buttons" in Excel? (https://www.excelbanter.com/excel-worksheet-functions/109062-how-do-i-create-push-buttons-excel.html)

LaToya

How do I create "push buttons" in Excel?
 
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.

Dave F

How do I create "push buttons" in Excel?
 
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
--
Brevity is the soul of wit.


"LaToya" wrote:

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.


Gord Dibben

How do I create "push buttons" in Excel?
 
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


On Fri, 8 Sep 2006 05:20:02 -0700, LaToya
wrote:

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.




All times are GMT +1. The time now is 06:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com