|
|
Chapter 1 Sample File.xlsx
|
XLSX
|
10.4 KB
|
|
|
Macro 1 Creating a New Workbook From Scratch.xlsm
|
XLSM
|
16.3 KB
|
|
|
Macro 10 Refresh All Data Connections in Workbook on Open.xlsm
|
XLSM
|
13.5 KB
|
|
|
Macro 100 Sending All Excel Charts to a PowerPoint Presentation.xlsm
|
XLSM
|
30.4 KB
|
|
|
Macro 101 Convert a Workbook into a PowerPoint Presentation.xlsm
|
XLSM
|
42.3 KB
|
|
|
Macro 11 Close all Workbooks in One Go.xlsm
|
XLSM
|
12.3 KB
|
|
|
Macro 12 Open all Workbooks in a Directory.xlsm
|
XLSM
|
14.2 KB
|
|
|
Macro 13 Print all Workbooks in a Directory.xlsm
|
XLSM
|
13 KB
|
|
|
Macro 14 Preventing the Workbook from Closing until a Cell is Populated.xlsm
|
XLSM
|
14.6 KB
|
|
|
Macro 15 Create a Backup of Current Workbook with Todays Date.xlsm
|
XLSM
|
14.1 KB
|
|
|
Macro 16 Adding and Naming a New Worksheet.xlsm
|
XLSM
|
14 KB
|
|
|
Macro 17 Delete all but the Active Worksheet.xlsm
|
XLSM
|
21.8 KB
|
|
|
Macro 18 Hide all but the Active Worksheet.xlsm
|
XLSM
|
21.8 KB
|
|
|
Macro 19 Unhide all Worksheets in a Workbook.xlsm
|
XLSM
|
18.1 KB
|
|
|
Macro 2 Saving a Workbook when a Particular Cell is changed.xlsm
|
XLSM
|
14.7 KB
|
|
|
Macro 20 Moving Worksheets Around.xlsm
|
XLSM
|
28.5 KB
|
|
|
Macro 21 Sort Worksheets by Name.xlsm
|
XLSM
|
22.2 KB
|
|
|
Macro 22 Group Worksheets by Color.xlsm
|
XLSM
|
23.7 KB
|
|
|
Macro 23 Copy a Worksheet to a new Workbook.xlsm
|
XLSM
|
19.1 KB
|
|
|
Macro 24 Create a New Workbook for Each Worksheet.xlsm
|
XLSM
|
22.1 KB
|
|
|
Macro 25 Print Specified Worksheets.xlsm
|
XLSM
|
20.3 KB
|
|
|
Macro 26 Protect all Worksheets.xlsm
|
XLSM
|
17.2 KB
|
|
|
Macro 27 Unprotect all Worksheets.xlsm
|
XLSM
|
20.3 KB
|
|
|
Macro 28 Create a Table of Contents for your Worksheets.xlsm
|
XLSM
|
23.9 KB
|
|
|
Macro 29 Zooming in and Out of a Worksheet with Double-Click.xlsm
|
XLSM
|
16.7 KB
|
|
|
Macro 3 Saving a Workbook Before Closing.xlsm
|
XLSM
|
13.1 KB
|
|
|
Macro 30 Highlight the Active Row and Column.xlsm
|
XLSM
|
18.2 KB
|
|
|
Macro 31 Selecting and Formatting a Range.xlsm
|
XLSM
|
18.1 KB
|
|
|
Macro 32 Creating and Selecting a Named Range.xlsm
|
XLSM
|
15.4 KB
|
|
|
Macro 33 Enumerating Through a Range of Cells.xlsm
|
XLSM
|
18.3 KB
|
|
|
Macro 34 Select and Format all Named Ranges.xlsm
|
XLSM
|
18.2 KB
|
|
|
Macro 35 Inserting Blank Rows in a Range.xlsm
|
XLSM
|
19.2 KB
|
|
|
Macro 36 Unhide All Rows and Columns.xlsm
|
XLSM
|
18.6 KB
|
|
|
Macro 37 Deleting Blank Rows.xlsm
|
XLSM
|
19.3 KB
|
|
|
Macro 38 Deleting Blank Columns.xlsm
|
XLSM
|
19.5 KB
|
|
|
Macro 39 Select and Format all Formulas in a Workbook.xlsm
|
XLSM
|
22.2 KB
|
|
|
Macro 4 Protect an Existing Workbook on Close.xlsm
|
XLSM
|
13.9 KB
|
|
|
Macro 40 Find and Select the First Blank Row or Column.xlsm
|
XLSM
|
20.8 KB
|
|
|
Macro 41 Apply Color Banding on Double-Click.xlsm
|
XLSM
|
20 KB
|
|
|
Macro 42 Sort a Range on Double-Click.xlsm
|
XLSM
|
17.3 KB
|
|
|
Macro 43 Limit Range Movement to a Particular Area.xlsm
|
XLSM
|
17 KB
|
|
|
Macro 44 Dynamically Set the Print Area of a Worksheet.xlsm
|
XLSM
|
18.2 KB
|
|
|
Macro 45 Copy and Paste a Range.xlsm
|
XLSM
|
19.5 KB
|
|
|
Macro 46 Convert All Formulas in a Range to Values.xlsm
|
XLSM
|
20.3 KB
|
|
|
Macro 47 Perform Text to Columns on all Columns.xlsm
|
XLSM
|
20 KB
|
|
|
Macro 48 Convert Trailing Minus Signs.xlsm
|
XLSM
|
20.4 KB
|
|
|
Macro 49 Trim Spaces from all Cells.xlsm
|
XLSM
|
19.8 KB
|
|
|
Macro 5 Unprotect an Existing Workbook on Open.xlsm
|
XLSM
|
13.7 KB
|
|
|
Macro 50 Truncate Postal Codes to the Left Five.xlsm
|
XLSM
|
19.6 KB
|
|
|
Macro 51 Padding Cells with Zeros.xlsm
|
XLSM
|
19.7 KB
|
|
|
Macro 52 Replace Blanks Cells with a Value.xlsm
|
XLSM
|
20.5 KB
|
|
|
Macro 53 Append Text to the Left or Right of your Cells.xlsm
|
XLSM
|
19.8 KB
|
|
|
Macro 54 Create a Super Data Cleanup Macro.xlsm
|
XLSM
|
22.1 KB
|
|
|
Macro 55 Clean up Non-Printing Characters.xlsm
|
XLSM
|
18.5 KB
|
|
|
Macro 56 Highlight Duplicates in a Range of Data.xlsm
|
XLSM
|
20.1 KB
|
|
|
Macro 57 Hide all but Duplicate Rows.xlsm
|
XLSM
|
20.3 KB
|
|
|
Macro 58 Selectively Hide AutoFilter Dropdowns.xlsm
|
XLSM
|
19 KB
|
|
|
Macro 59 Copy Filtered Rows to a New Workbook.xlsm
|
XLSM
|
20.3 KB
|
|
|
Macro 6 Open a Workbook to a Specific Tab.xlsm
|
XLSM
|
15.3 KB
|
|
|
Macro 60 Create New Sheet for Each Item in an AutoFilter.xlsm
|
XLSM
|
23.6 KB
|
|
|
Macro 61 Show Filtered Columns in Status Bar.xlsm
|
XLSM
|
17.9 KB
|
|
|
Macro 62 Create a Backwards Compatible PivotTable.xlsm
|
XLSM
|
4.5 MB
|
|
|
Macro 63 Refresh All Pivot Tables Workbook.xlsm
|
XLSM
|
8.3 MB
|
|
|
Macro 64 Create A PivotTable Inventory Summary.xlsm
|
XLSM
|
8.3 MB
|
|
|
Macro 65 Make All Pivot Tables use the Same Pivot Cache.xlsm
|
XLSM
|
5.8 MB
|
|
|
Macro 66 Hide All Subtotals in a Pivot Table.xlsm
|
XLSM
|
1.3 MB
|
|
|
Macro 67 Adjust All Pivot Data Field Titles.xlsm
|
XLSM
|
1.3 MB
|
|
|
Macro 68 Set All Data Items to Sums.xlsm
|
XLSM
|
1.3 MB
|
|
|
Macro 69 Apply Number Formatting for All Data Items.xlsm
|
XLSM
|
5.7 MB
|
|
|
Macro 7 Opening a Specific Workbook Defined by the User.xlsm
|
XLSM
|
16 KB
|
|
|
Macro 70 Sort All Fields in Alphabetical Order.xlsm
|
XLSM
|
1.3 MB
|
|
|
Macro 71 Apply Custom Sort to Data Items.xlsm
|
XLSM
|
1.3 MB
|
|
|
Macro 72 Apply Pivot Table Restrictions.xlsm
|
XLSM
|
5.7 MB
|
|
|
Macro 73 Apply Pivot Field Restrictions.xlsm
|
XLSM
|
1.3 MB
|
|
|
Macro 74 Automatically Delete Pivot Table Drilldown Sheets.xlsm
|
XLSM
|
1.3 MB
|
|
|
Macro 75 Print Pivot Table for Each Report Filter.xlsm
|
XLSM
|
1.3 MB
|
|
|
Macro 76 Create New Workbook Fore Each Report Filter.xlsm
|
XLSM
|
1.1 MB
|
|
|
Macro 77 Transpose Entire Data Range With a PivotTable.xlsm
|
XLSM
|
31.1 KB
|
|
|
Macro 78 Resize All Charts on a Worksheet.xlsm
|
XLSM
|
27.2 KB
|
|
|
Macro 79 Align Chart to a Specific Range.xlsm
|
XLSM
|
28.9 KB
|
|
|
Macro 8 Determine if a Workbook is Already Open.xlsm
|
XLSM
|
19.8 KB
|
|
|
Macro 80 Create a Set of Disconnected Charts.xlsm
|
XLSM
|
29.2 KB
|
|
|
Macro 81 Print All Charts on a Worksheet.xlsm
|
XLSM
|
26.3 KB
|
|
|
Macro 82 Automatically Label First and Last Chart Points.xlsm
|
XLSM
|
22.3 KB
|
|
|
Macro 83 Color Chart Series to Match Source Cell Colors.xlsm
|
XLSM
|
21.6 KB
|
|
|
Macro 84 Color Chart Data Points to Match Source Cell Colors.xlsm
|
XLSM
|
19.9 KB
|
|
|
Macro 85 Mailing the Active Workbook as Attachment.xlsm
|
XLSM
|
15.5 KB
|
|
|
Macro 86 Mailing a Specific Range as Attachment.xlsm
|
XLSM
|
17.9 KB
|
|
|
Macro 87 Mailing a Single Sheet as an Attachment.xlsm
|
XLSM
|
20.7 KB
|
|
|
Macro 88 Send Mail with a link to Your Workbook.xlsm
|
XLSM
|
17.6 KB
|
|
|
Macro 89 Mailing All Email Addresses in Your Contact List.xlsm
|
XLSM
|
19.6 KB
|
|
|
Macro 9 Determine if a Workbook Exists in a Directory.xlsm
|
XLSM
|
14.3 KB
|
|
|
Macro 90 Saving All Attachments to a Folder.xlsm
|
XLSM
|
18.9 KB
|
|
|
Macro 91 Saving Certain Attachments to a Folder.xlsm
|
XLSM
|
19.1 KB
|
|
|
Macro 92 Running an Access Query from Excel.xlsm
|
XLSM
|
13.5 KB
|
|
|
Macro 93 Running an Access Macro from Excel.xlsm
|
XLSM
|
15.1 KB
|
|
|
Macro 94 Running an Access Reprot from Excel.xlsm
|
XLSM
|
13.7 KB
|
|
|
Macro 95 Opening an Access Form from Excel.xlsm
|
XLSM
|
13.6 KB
|
|
|
Macro 96 Compacting an Access Database from Excel.xlsm
|
XLSM
|
15.2 KB
|
|
|
Macro 97 Sending Excel Data to a Word Document.xlsm
|
XLSM
|
20.2 KB
|
|
|
Macro 98 Simulating Mail Merge with a Word Document.xlsm
|
XLSM
|
23.3 KB
|
|
|
Macro 99 Sending Excel Data to a PowerPoint Presentation.xlsm
|
XLSM
|
29.5 KB
|
|
|
MailMerge.docx
|
DOCX
|
14.7 KB
|
|
|
PasteTable.docx
|
DOCX
|
17.5 KB
|
