Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,574
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to create a mailing list in excel, not importing d. Claire Bardot New Users to Excel 3 December 29th 05 11:20 PM
create excel based standalone application Pete_R Excel Discussion (Misc queries) 0 December 4th 05 11:59 PM
how to create the formula "cumsum" in excel paulc59 Excel Worksheet Functions 5 November 26th 05 02:58 AM
Create New Microsoft Excel Worksheet Has 3 Sheets Bassam Setting up and Configuration of Excel 0 February 9th 05 08:51 PM
create price list from excel sheet -keevill- Excel Discussion (Misc queries) 1 February 8th 05 12:02 AM


All times are GMT +1. The time now is 07:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"