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
