Page 17 - Excel 2013 All-in-One For Dummies

Table of Contents xv Book VIII: Macros and VBA....................................... 707
Chapter 1: Building and Running Macros . . . . . . . . . . . . . . . . . . . . . . .709
Macro Basics ................................................................................................ 710 Recording macros.............................................................................. 710 Running a macro ................................................................................ 715
Macro Security.............................................................................................716 Assigning Macros to the Ribbon and the Quick Access Toolbar .......... 718 Adding your macros to a custom tab on the Ribbon....................718
Adding your macros to custom buttons
on the Quick Access toolbar......................................................... 719
Chapter 2: VBA Programming . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .721
Using the Visual Basic Editor.....................................................................722 Editing recorded macros .................................................................. 724 Writing new macros in the Visual Basic Editor.............................. 733
Creating Custom Excel Functions.............................................................. 735 Adding a description to a user-defined function ........................... 737 Using a custom function in your spreadsheet ............................... 738 Saving custom functions in add-in files........................................... 741
Index ....................................................................... 745