button to jump to another worksheet
 

I need a macro to jump to display another worksheet within the same
workbook when a button is pushed. I tried to use a control button and
then insert a hyperlink, but the hyperlink only works while in design
mode. What I want to do is display the button on one worksheet and
when it is pressed jump to another worksheet. I know this must be
something simple that I am just missing. help!?

button to jump to another worksheet
 

To link to a location in the current workbook or another workbook, you
can either define a name (name: A word or string of characters that
represents a cell, range of cells, formula, or constant value. Use
easy-to-understand names, such as Products, to refer to hard to
understand ranges, such as Sales!C20:C30.) for the destination
(destination: General term for the name of the element you go to from a
hyperlink.) cells or use a cell reference.

To use a name, name the destination cells in the destination workbook.

How?

Select the cell, range of cells, or nonadjacent selections (nonadjacent
selection: A selection of two or more cells or ranges that don't touch
each other. When plotting nonadjacent selections in a chart, make sure
that the combined selections form a rectangular shape.) that you want
to name.
Click the Name box at the left end of the formula bar (formula bar: A
bar at the top of the Excel window that you use to enter or edit values
or formulas in cells or charts. Displays the constant value or formula
stored in the active cell.) .


Name box

Type the name for the cells.
Press ENTER.
Note You cannot name a cell while you are changing the contents of the
cell.

In the source (source file: The file that contains information that was
used to create a linked or embedded object. When you update the
information in the source file, you can also update the linked object
in the destination file.) workbook, right-click the text or graphic you
want to represent the hyperlink (hyperlink: Colored and underlined text
or a graphic that you click to go to a file, a location in a file, a
Web page on the World Wide Web, or a Web page on an intranet.
Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP
sites.), and then click Hyperlink on the shortcut menu.
Do one of the following:
To link to a location in your current workbook, click Place in this
document under Link to.

To link to a location in another workbook, click Existing file or Web
page under Link to.

If you chose Existing file or Web page, locate and select the workbook
you want to link to, and then click the Bookmark button.
Do one of the following:
In the list under Cell Reference, click the sheet you want to link to,
and then type the cell reference in the Type in the cell reference box.
Click OK.

In the list under Defined Names, click the name that represents the
cells you want to link to. Click OK.

To assign a tip to be displayed when you rest the pointer on the
hyperlink, click ScreenTip and then type the text you want in the
ScreenTip text box. Click OK.


--
rockofaith
------------------------------------------------------------------------
rockofaith's Profile: http://www.excelforum.com/member.php...o&userid=34494
View this thread: http://www.excelforum.com/showthread...hreadid=542597

button to jump to another worksheet
 

I don't see a role for a hyperlink.

Private Sub CommandButton1_Click()
Worksheets("Sheet3").Activate
End Sub

--
Regards,
Tom Ogilvy


"jim9912" wrote:

I need a macro to jump to display another worksheet within the same
workbook when a button is pushed. I tried to use a control button and
then insert a hyperlink, but the hyperlink only works while in design
mode. What I want to do is display the button on one worksheet and
when it is pressed jump to another worksheet. I know this must be
something simple that I am just missing. help!?

button to jump to another worksheet
 

Thank you -- I wasn't familiar with the "activate" function. Works
great.