Putting Macro on Toolbar Click and drag the Command to the floating Toolbar Drop the Command on the Toolbar Įditing Macro on Toolbar Right Click on the new Toolbar Click in Name: Enter Name- no spaces Change button image: Select image Īnchoring Toolbar – Using Macro Double click on the floating Toolbar to anchor it To use, just Click the icon and the document will open. Putting Macro on Toolbar A floating Toolbar will open Click the COMMANDS Tab Select Category MACRO Select the Command (Macro Name) Putting Macro on Toolbar Select the TOOLBAR Tab Click NEW Name the new toolbar MACROS Click OK
Putting Macro on Toolbar The Customize Dialog Box will open Putting Macro on Toolbar Right click in the Toolbar Select Customize Running the Macro in Word 2003 To run the macros (continued): Select the macro Click RUN Running the Macro in Word 2003 To just run the macros: TOOLS MACRO MACROS Open the document Stop the macro Example
Summary – Creating Macro in Word 2003 Summary of Steps: Start the macro Navigate to the document, etc. Why use macros? Increase productivity Less key strokes Place macros on toolbar No more searching for frequently used documents Ĭreating a Macro in Word 2003 From the Menu TOOLS MACROS RECORD NEW MACRO Ĭreating a Macro in Word 2003 Name the Macro Click TOOLBAR The Customize dialog box may open – click CLOSE Ĭreating a Macro in Word 2003 The Stop/Pause buttons will appear Begin recording your macro Įxample Macro - Letterhead Navigate to the document In this example it is in the Templates, so FILE NEW ON MY COMPUTER Select the Document Įxample Macro - Letterhead Document will open Click STOP to quit recording the macro Close the document What is a Macro? Used for repetitive tasks Recording of key strokes It’s an action or set of actions that you can use to automate tasks If you are still using Excel 95, the easiest way to create a macro from scratch is to first record a "dummy" macro, and then edit that macro to create your final "from scratch" macro.Creating Macros Word and Excel 2003 Administrative Support Network Sharon Burks March 27, 2008
(You can also paste macro code from other sources, such as ExcelTips.) Visual Basic for Applications will start up and you can write your macro. In the Macro Name box, type a descriptive name you want assigned to the macro you are writing.In the Macros In box (at the bottom of the dialog box), select where you want your new macro stored.Choose the Macro option from the Tools menu, then choose Macros from the resulting submenu.To create a macro from scratch, follow these steps: The second method of creating a macro, writing one from scratch, is much more powerful.
First you can record a macro, which is appropriate when you want to record a series of steps you perform quite often. There are actually two ways you can create macros.
Some readers may not know how to enter a macro from scratch in Excel. Many of the tips used in ExcelTips rely upon macros in order to run.