Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |