course excel in london - Macro

Resolved · Low Priority · Version Standard

Fri 23 Nov 2007, 12:59 Delegate 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:29 Trainer 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

Excel tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010

When 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.

After you have done this, remember to click on the tabs to take them out of the group so that you do not accidentally insert data in multiple sheets when you just want to insert data in one.

View all Excel hints and tips

course excel in london - Macro

Macro

Insert / Delete Button On Spreadsheet to run Macro

Excel articles

Excel tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010