Introduction ....................................................................................1
   What Is in This Book? ................................................................1
       Reducing the Learning Curve ......................................1
       Excel VBA Power .................................................................2
       Techie Stuff Needed to Produce Applications ......................................................................................2
       Does This Book Teach Excel? ........................................2
   The Future of VBA and Windows Versions of Excel .....................................................................................4
       Versions of Excel .................................................................4
       Differences for Mac Users ..............................................4
   Special Elements and Typographical Conventions ......................................................................................5
   Code Files .........................................................................................5
   Next Steps ........................................................................................5
1 Unleashing the Power of Excel with VBA .................................................................................7
   The Power of Excel ......................................................................7
   Barriers to Entry ...........................................................................7
       The Macro Recorder Doesn’t Work! .........................7
       No One on the Excel Team Is Focused on the Macro Recorder ..................................................8
       Visual Basic Is Not Like BASIC......................................8
       Good News: Climbing the Learning Curve Is Easy .............................................................................9
       Great News: Excel with VBA Is Worth the Effort .................................................................................9
   Knowing Your Tools: The Developer Tab .........................9
   Understanding Which File Types Allow Macros .........................................................................................10
   Macro Security ...........................................................................12
       Adding a Trusted Location .........................................12
       Using Macro Settings to Enable Macros in Workbooks Outside Trusted Locations ..................................................13
       Using D