Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Buttons
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Buttons
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... ----------------------------------------------------------------------- "Gor_yee" wrote in message ups.com... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Buttons
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??? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Buttons
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... ----------------------------------------------------------------------- "Gor_yee" wrote in message oups.com... 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??? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Buttons
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 "Gor_yee" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
have toggle buttons but everytime print preview buttons move | Excel Discussion (Misc queries) | |||
pivot chart is it possible to hide individual field buttons? Layout Field buttons | Charts and Charting in Excel | |||
Buttons | Excel Discussion (Misc queries) | |||
Buttons | Excel Worksheet Functions | |||
Buttons | Excel Discussion (Misc queries) |