Free Microsoft Office Tutorials | Online Office Learning Guide | Microsoft Office Tips and Tricks

• · To record a macro
• From the Tools menu, point to Macro and click on Record New Macro.
• From the Record Macro dialog box displayed, enter a name for the macro in the Macro name: text box.

• The default description is displayed in the Description: text box, and contains the date and user name. If required, change it.
• To begin recording, click OK.
• Perform the actions you want the macro to record. Actions can be any combinations of Excel commands.
• To stop recording, from the Tools menu, point to Macro and click on Stop Recording.

To assign a shortcut key to the macro

• From the Tools menu, point to Macro and click on Macros.
• From the Macro dialog box displayed, select the macro name (if recorded before) to which you want to assign a shortcut key.

• Click the Options button to display the Macro Options dialog box.
• Type a letter into the Ctrl+ text box. This combination key will be used to invoke the macro.
• Click OK to return to the Macro dialog box.
• Click on the Cancel button to close.

To run a macro using the Tools Macro command

• From the Tools menu, point to Macro and click on Macros.
• From the Macro dialog box displayed, click on the name of the macro you wish to run in the Macro name: list box.
• Click the Run button.Note: If you wish to edit or delete a macro, just click on the particular button.

To run a macro using the assigned shortcut key

• Press Ctrl+?, with ? is the letter which you assigned.

To create a button and assign an Excel macro to it

• If the Forms toolbar is not display, right click on any toolbar that is visible and from the pop-up menu that is displayed select Forms.
• To create a button, click the Button icon on the Forms toolbar.

• Then, click and drag the mouse to the intended button size.
• When release the mouse button, the Assign Macro dialog box will be displayed.

• Click on the Record button and the Record Macro dialog box will be displayed.
• Enter a name for the macro in the Macro name: text box.
• Click on the OK button.
• Record your macro in the normal way, and click on the button and select Edit Text from the pop-up menu.
• To run the macro, simply click on the button.

To change a button name

• Double click on the button to highlight the button name.
• Type in a new name and click on any worksheet cell to deselect the button.

To delete a button

• Click on button and press the Delete key.

Bookmark it:

Popularity: 11% [?]

Macros are advanced features that can speed up editing or formatting you may perform often in an Excel worksheet. They record sequences of menu selections that you choose so that a series of actions can be completed in one step.

Recording a Macro
To record a Macro:

• Click the View tab on the Ribbon
• Click Macros
• Click Record Macro
• Enter a name (without spaces)
• Enter a Shortcut Key
• Enter a Description

• Perform the Macro
• Click Marcos
• Click Stop Recording

Running a Macro
To run a Macro from the Keyboard shortcut, simply press the keys that you have programmed to run the Macro. Or you can view all macros and run by:

• Click Macros
• Click View Macros
• Choose the Macro and click Run

Bookmark it:

Popularity: 13% [?]

Macros are advanced features that can speed up editing or formatting you may perform often in a Word document. They record sequences of menu selections that you choose so that a series of actions can be completed in one step.

Recording a Macro
To record a Macro:

• Click the View Tab on the Ribbon
• Click Macros
• Click Record Macro

• Enter a name (without spaces)
• Click whether you want it assigned to a button (on the Quick Access Toolbar) or the keyboard (a sequence of keys)
• To assign the macro a button on the Quick Access Toolbar:
  • Click Button
  • Under the Customize Quick Access Toolbar, select the document for which you want the Macro available

• • Under Choose Commands: Click the Macro that you are recording
  • Click Add
  • Click OK to begin Recording the Macro
  • Perform the actions you want recorded in the Macro
  • Click on Macros
  • Click on Stop Recording Macros

• To assign a macro button to a keyboard shortcut:
  • Click Keyboard
  • In the Press New Shortcut Key box, type the key sequence that you want and click Assign

• • Click Close to begin recording the Macro
  • Perform the actions you want recorded in the Macro
  • Click on Macros
  • Click on Stop Recording Macros

Running a Macro
Running a macro depends on whether it’s been added to the Quick Access Toolbar or if it’s been given a Keyboard Shortcut.

• To run a Macro from the Quick Access Toolbar, simply click the Macro Icon

• To run a Macro from the Keyboard shortcut, simply press the keys that you have programmed to run the Macro.

Bookmark it:

Popularity: 12% [?]