Buttons

  • Thread starter Thread starter Gor_yee
  • Start date Start date
G

Gor_yee

Hi all, how do I create a button within an image that when i press it,
it will take me to a particular cell on another worksheet??Is excel
able to do this??Please help
 
Johnnie,

Create the button using the Drawing Toolbar (usually docked at the bottom of the screen).
Then right-click the button, and select Hyperlink. Set it up for "Place in this document."

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
Hi Earl,

thanks for the reply...

I've created a button on top of a picture...but the hyperlink is
greyed out??I am unable to select?What could be causing this
problem???
 
Johnnie,

I made a button over a picture and was able to set it hyperlink properties. If I selected
both the picture and the button, then it was grayed out. That's all I can think of.

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
 
Hi,

Do the following:

1. On the View menu, point to Toolbars, and then click Forms.
The Forms toolbar displays.
2. Click the "Button" icon in the Forms toolbar. The cursor pointer changes
to "+".
3. Click on the worksheet and drag diagonally to create a button.
The Assign Macro dialog box is displayed.
4. Do one of the followin:

* Associate a Macro name to the button by click the name in the Macro list.
* Create a New macro by clicking the New button
* Click Record to record a new macro.

Note: Click on the Record button to allow Microsoft Excel to store all the
actions you perform. The Record Macro dislog box is displayed. Enter a Macro
name and click OK. The Stop recording toolbar appears. Click Sheet2 tan and
then click on cell A1.. Click on the Stop Recording icon in the Stop
recording toolbar.

5. Once you associate a Macro to a button, only then the pointer becomes a
finger when you hover your mouse point over the button.
6. Click the button to verify that you move to a new cell location.
7. Right-click the button and select Edit Text to rename the button.

Challa Prabhu
 
Back
Top