| Description |
1 online resource (1 volume) : illustrations |
| Series |
For dummies |
|
--For dummies.
|
| Contents |
Storing macros in your personal macro workbookAssigning a macro to a button and other form controls; Placing a macro on the Quick Access toolbar; Examples of Macros in Action; Building navigation buttons; Dynamically rearranging pivot table data; Offering one-touch reporting options; Chapter 2 Getting Cozy with Visual Basic Editor; Working in Visual Basic Editor; Understanding VBE components; Working with the Project Window; Adding a new VBA module; Removing a VBA module; Working with a Code Window; Minimizing and maximizing windows; Getting VBA code into a module |
|
Customizing the VBA EnvironmentThe Editor tab; The Editor Format tab; The General tab; The Docking tab; Chapter 3 The Anatomy of Macros; An Overview of the Excel Object Model; Understanding objects; Understanding collections; Understanding properties; Understanding methods; A Brief Look at Variables; Understanding Event Procedures; Worksheet events; Workbook events; Error Handling in a Nutshell; On Error GoTo SomeLabel; On Error Resume Next; On Error GoTo 0; Part II Making Short Work of Workbook Tasks; Chapter 4 Working with Workbooks; Creating a Workbook from Scratch; How the macro works |
|
How the macro worksHow to use the macro; Determining Whether a Workbook Exists in a Directory; How the macro works; How to use the macro; Closing All Workbooks at Once; How the macro works; How to use the macro; Printing All Workbooks in a Directory; How the macro works; How to use the macro; Preventing the Workbook from Closing Until a Cell Is Populated; How the macro works; How to use the macro; Creating a Backup of a Current Workbook with Today's Date; How the macro works; How to use the macro; Chapter 5 Working with Worksheets; Adding and Naming a New Worksheet; How the macro works |
| Summary |
Ready-made Excel macros that will streamline your workflow Excel Macros For Dummies helps you save time, automate, and be more productive, even with no programming experience at all. Each chapter offers practical macros that you can implement right away, with practical exercises that extend your knowledge and help you understand the mechanics at work. You'll find the most effective Excel macros for solving common problems, and explanations of why and where to use each one, plus invaluable guidance and step-by-step instruction for applying them effectively. Learn how to customize your applica |
| Notes |
Date of publication from resource description page |
|
Online resource; title from cover (Safari, viewed November 18, 2019) |
| SUBJECT |
Microsoft Excel (Computer file) http://id.loc.gov/authorities/names/n86025775
|
|
Microsoft Excel (Computer file) fast |
| Subject |
Electronic spreadsheets -- Computer programs.
|
|
Macro instructions (Electronic computers)
|
|
Electronic spreadsheets -- Computer programs
|
|
Macro instructions (Electronic computers)
|
| Form |
Electronic book
|
| ISBN |
9781119089353 |
|
1119089352 |
|
