Visual Basic for Applications/Editing Macros

This lesson introduces editing macros.

Objectives and Skills
Objectives and skills for editing macros include:
 * Setting procedure options by using the Macro Options dialog box
 * Modifying the Visual Basic development environment

Readings

 * 1) Microsoft: Create or Delete a Macro
 * 2) Excel-Easy: Create a Macro
 * 3) Microsoft: Run a Macro
 * 4) Microsoft: MsgBox Function
 * 5) Home & Learn: The Excel Visual Basic for Applications Development Environment

Multimedia

 * 1) YouTube: Excel VBA MsgBox Tutorial

Activities

 * 1) Display content in a message box.
 * 2) Using Excel, create a new macro that uses MsgBox to display "Hello !".  Insert your name in the macro.
 * 3) Experiment with running your macro using , using the Macros dialog box, and assigning a shortcut key.
 * 4) Run a macro.
 * 5) Run your Hello macro using a button on the Quick Access toolbar.
 * 6) Run your Hello macro using a button in a custom tab or custom group on the Ribbon.
 * 7) Run your Hello macro using a graphic object area.
 * 8) Run a macro automatically.
 * 9) Configure your Hello macro to run automatically whenever the workbook is opened Auto_Open.
 * 10) Test your macro to ensure that it runs automatically.
 * 11) Test holding down the Shift key to prevent your macro from running automatically.
 * 12) Research VBA malware.
 * 13) Review SC Magazine: VBA Malware on the Rise.
 * 14) Consider how easy it is to create malware using VBA.
 * 15) Research and consider ways to protect yourself from VBA malware.