Mastering VBA for Microsoft Office 2007, 2nd Edition

Appendix

The Bottom Line Solutions

Each of The Bottom Line sections in the chapters challenge your understanding of the chapters’ concepts and improve your skills.

Chapter 1: Recording and Running Macros in the Microsoft Office Applications

Record a macro

The easiest way to create a macro is to simply record it. Whatever you type or click — all your behaviors — are translated into VBA automatically and saved as a macro.

Master It Turn on the Macro Recorder in Word and create a macro that moves the insertion cursor up three lines. Then turn off the Macro Recorder and view the code in the Visual Basic Editor.

Solution Click the Developer tab on the Ribbon (if that tab isn’t visible, press Alt+F, I and select Show Developer Tab in the Ribbon). Click ...