href="#ulink_998fcd04-6809-595a-83bf-1564b59bbe78">Creating a New Workbook from Scratch
Saving a Workbook when a Particular Cell Is Changed
Saving a Workbook before Closing
Protecting a Worksheet on Workbook Close
Unprotecting a Worksheet
Opening a Workbook to a Specific Tab
Opening a Specific Workbook Defined by the User
Determining Whether a Workbook Is Already Open
Determining Whether a Workbook Exists in a Directory
Closing All Workbooks at Once
Printing All Workbooks in a Directory
Preventing the Workbook from Closing Until a Cell Is Populated
Creating a Backup of the Current Workbook with Today’s Date
Chapter 5: Working with Worksheets
Installing Macros
Adding and Naming a New Worksheet
Deleting All but the Active Worksheet
Hiding All but the Active Worksheet
Unhiding All Worksheets in a Workbook
Moving Worksheets Around
Sorting Worksheets by Name
Grouping Worksheets by Color
Copying a Worksheet to a New Workbook
Creating a New Workbook for Each Worksheet
Printing Specified Worksheets
Protecting All Worksheets
Unprotecting All Worksheets
Creating a Table of Contents for Your Worksheets
Zooming In and Out of a Worksheet with Double-Click
Highlighting the Active Row and Column
7 Part 3: One-Touch Data Manipulation Chapter 6: Feeling at Home on the Range Installing Macros Selecting and Formatting a Range Creating and Selecting Named Ranges Looping Through a Range of Cells Inserting Blank Rows in a Range Unhiding All Rows and Columns Deleting Blank Rows Deleting Blank Columns Limiting Range Movement to a Particular Area Selecting and Formatting All Formulas in a Workbook Finding and Selecting the First Blank Row or Column Chapter 7: Manipulating Data with Macros Installing Macros Copying and Pasting a Range Converting All Formulas in a Range to Values Text to Columns on All Columns Converting Trailing Minus Signs Trimming Spaces from All Cells in a Range Truncating Zip Codes to the Left Five Padding Cells with Zeros Replacing Blanks Cells with a Value Appending Text to the Left or Right of Your Cells Cleaning Up Non-Printing Characters Highlighting Duplicates in a Range of Data Hiding All but Rows Containing Duplicate Data Selectively Hiding AutoFilter Drop-down Arrows Copying Filtered Rows to a New Workbook Showing Filtered Columns in the Status Bar
8 Part 4: Macro-Charging Reports and Emails Chapter 8: Automating Common Reporting Tasks Installing Macros Refreshing All PivotTables in a Workbook Creating a List of PivotTables Adjusting All Pivot Data Field Titles Setting All Data Items to Sum Applying Number Formatting for All Data Items Sorting All Fields in Alphabetical Order Applying a Custom Sort to Data Items Applying PivotTable Restrictions Applying Pivot Field Restrictions Automatically
