90 likes | 271 Views
ME 142 Engineering Computation I. Macros. Key Concepts. Macro Overview Recording a Macro Running a Macro Editing a Macro. Macro Overview. A macro is a short program or set of recorded keystrokes Stored as VBA program Great for repetitive tasks Can be edited
E N D
Key Concepts Macro Overview Recording a Macro Running a Macro Editing a Macro
Macro Overview • A macro is a short program or set of recorded keystrokes • Stored as VBA program • Great for repetitive tasks • Can be edited • Great way to learn new VBA functions
Recording a Macro • Recording of a macros can be launched from the View and Developer tabs or the lower left of the spreadsheet window
Recording a Macro • Select Use Relative References button, if desired, prior to recording macro
Recording a Macro • Prior to recording the macro, a dialog box is displayed • Note in particular: • Shortcut key • Storage location
Ending a Macro Recording • Use the Stop Recording button on from the View or Developer tabs or the lower left of the spreadsheet window
Running a Macro • Click on Macro from the View or Developer ribbons to list available macros • May also use previously assigned shortcut key combination to launch macro
Editing a Macro • Edit a Macro as you would any VBA program • Alternately may launch editor by clicking on Macro in the View or Developer ribbons and selecting Edit