Fri 23 Nov 2007, 12:59Delegate Phylli said...
Phylli has attended:
Excel Advanced course
Macro
how do I insert or delete a macro button from a spreadsheet?
Fri 23 Nov 2007, 14:28
Edited on Fri 23 Nov 2007, 14:29Trainer Carlos said...
Insert / Delete Button On Spreadsheet to run Macro
Phylli
To place a button on the spreadsheet:
1. In the View menu / Select Toolbars
2. Click Forms
The Forms toolbar appears.
3. Click the Button icon.
4. With your mouse draw a button on the screen
The Assign Macro dialog box appears
5. Select the required macro
6. Click OK
7. Change the text on the button
8. Click Off the button.
The next time you click on the button it will run the macro.
To Delete the Buutton
Right-Click the Button and Click Cut
Hope this helps
Carlos
