Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » course excel in london - Macro
Resolved · Low Priority · Version Standard
Phylli has attended:
Excel Advanced course
how do I insert or delete a macro button from a spreadsheet?
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
|
Excel tip:How to apply the same formatting and data to multiple sheets at the same time in Excel 2010When you want to format more than one sheet in a worksheet exactly the same way, Ctrl-click the tabs of the sheets you want to group together and they will all turn white. While they are grouped, anything you enter in one sheet gets entered into the others. |
We'll call during UK business hours
Server loaded in 0.09 secs.