Normal view MARC view ISBD view

101 Ready-To-Use Excel Macros.

By: Alexander, Michael.
Contributor(s): Walkenbach, John.
Material type: TextTextSeries: eBooks on Demand.Publisher: Hoboken : Wiley, 2012Description: 1 online resource (338 p.).ISBN: 9781118333532.Subject(s): Electronic spreadsheets - Computer programs | Macro instructions (Electronic computers) | Microsoft Excel (Computer file) | Microsoft Visual Basic for applicationsGenre/Form: Electronic books.Additional physical formats: Print version:: 101 Ready-To-Use Excel MacrosDDC classification: 005.369 | 005.54 Online resources: Click here to view this ebook.
Contents:
101 Ready-to-Use Excel® Macros; About the Authors; Dedication; Authors' Acknowledgments; Contents at a Glance; Table of Contents; Introduction; Topics Covered; What You Need to Know; What You Need to Have; How This Book Is Organized; Conventions in This Book; About the Companion Website; PART I: Getting Started with Excel Macros; Becoming Familiar with Macro Recording Basics; Comparing Absolute and Relative Macro Recording; Looking at Other Macro Recording Concepts; Working in the Visual Basic Editor; Working with the Project window; Working with a Code Window; Customizing the VBA Environment
Discovering the Excel Object ModelTaking a Brief Look at Variables; About the Macros in This Book; PART II: Working with Workbooks; Macro 1: Creating a New Workbook from Scratch; Macro 2: Saving a Workbook When a Particular Cell Is Changed; Macro 3: Saving a Workbook Before Closing; Macro 4: Protect a Worksheet on Workbook Close; Macro 5: Unprotect a Worksheet on Workbook Open; Macro 6: Open a Workbook to a Specific Tab; Macro 7: Opening a Specific Workbook Defined by the User; Macro 8: Determine Whether a Workbook Is Already Open; Macro 9: Determine Whether a Workbook Exists in a Directory
Macro 10: Refresh All Data Connections in Workbook on OpenMacro 11: Close All Workbooks at Once; Macro 12: Open All Workbooks in a Directory; Macro 13: Print All Workbooks in a Directory; Macro 14: Preventing the Workbook from Closing Until a Cell Is Populated; Macro 15: Create a Backup of a Current Workbook with Today's Date; PART III: Automating Worksheet Tasks with Macros; Macro 16: Add and Name a New Worksheet; Macro 17: Delete All but the Active Worksheet; Macro 18: Hide All but the Active Worksheet; Macro 19: Unhide All Worksheets in a Workbook; Macro 20: Moving Worksheets Around
Macro 21: Sort Worksheets by NameMacro 22: Group Worksheets by Color; Macro 23: Copy a Worksheet to a New Workbook; Macro 24: Create a New Workbook for Each Worksheet; Macro 25: Print Specified Worksheets; Macro 26: Protect All Worksheets; Macro 27: Unprotect All Worksheets; Macro 28: Create a Table of Contents for Your Worksheets; Macro 29: Zooming In and Out of a Worksheet with Double-Click; Macro 30: Highlight the Active Row and Column; PART IV: Selecting and Modifying Ranges; Macro 31: Selecting and Formatting a Range; Macro 32: Creating and Selecting Named Ranges
Macro 33: Enumerating Through a Range of CellsMacro 34: Select and Format All Named Ranges; Macro 35: Inserting Blank Rows in a Range; Macro 36: Unhide All Rows and Columns; Macro 37: Deleting Blank Rows; Macro 38: Deleting Blank Columns; Macro 39: Select and Format All Formulas in a Workbook; Macro 40: Find and Select the First Blank Row or Column; Macro 41: Apply Alternate Color Banding; Macro 42: Sort a Range on Double-Click; Macro 43: Limit Range Movement to a Particular Area; Macro 44: Dynamically Set the Print Area of a Worksheet; PART V: Working with Data
Macro 45: Copy and Paste a Range
Summary: Save time and be more productive with this helpful guide to Excel macros! While most books about Excel macros offer only minor examples, usually aimed at illustrating a particular topic, this invaluable resource provides you with the tools needed to efficiently and effectively program Excel macros immediately. Step-by-step instructions show you how to create VBA macros and explain how to customize your applications to look and work exactly as you want them to. By the end of the book, you will understand how each featured macro works, be able to reuse the macros included in the book an
Tags from this library: No tags from this library for this title. Log in to add tags.
Item type Current location Call number URL Status Date due Barcode
Electronic Book UT Tyler Online
Online
QA76.6 (Browse shelf) http://uttyler.eblib.com/patron/FullRecord.aspx?p=832616 Available EBL832616

101 Ready-to-Use Excel® Macros; About the Authors; Dedication; Authors' Acknowledgments; Contents at a Glance; Table of Contents; Introduction; Topics Covered; What You Need to Know; What You Need to Have; How This Book Is Organized; Conventions in This Book; About the Companion Website; PART I: Getting Started with Excel Macros; Becoming Familiar with Macro Recording Basics; Comparing Absolute and Relative Macro Recording; Looking at Other Macro Recording Concepts; Working in the Visual Basic Editor; Working with the Project window; Working with a Code Window; Customizing the VBA Environment

Discovering the Excel Object ModelTaking a Brief Look at Variables; About the Macros in This Book; PART II: Working with Workbooks; Macro 1: Creating a New Workbook from Scratch; Macro 2: Saving a Workbook When a Particular Cell Is Changed; Macro 3: Saving a Workbook Before Closing; Macro 4: Protect a Worksheet on Workbook Close; Macro 5: Unprotect a Worksheet on Workbook Open; Macro 6: Open a Workbook to a Specific Tab; Macro 7: Opening a Specific Workbook Defined by the User; Macro 8: Determine Whether a Workbook Is Already Open; Macro 9: Determine Whether a Workbook Exists in a Directory

Macro 10: Refresh All Data Connections in Workbook on OpenMacro 11: Close All Workbooks at Once; Macro 12: Open All Workbooks in a Directory; Macro 13: Print All Workbooks in a Directory; Macro 14: Preventing the Workbook from Closing Until a Cell Is Populated; Macro 15: Create a Backup of a Current Workbook with Today's Date; PART III: Automating Worksheet Tasks with Macros; Macro 16: Add and Name a New Worksheet; Macro 17: Delete All but the Active Worksheet; Macro 18: Hide All but the Active Worksheet; Macro 19: Unhide All Worksheets in a Workbook; Macro 20: Moving Worksheets Around

Macro 21: Sort Worksheets by NameMacro 22: Group Worksheets by Color; Macro 23: Copy a Worksheet to a New Workbook; Macro 24: Create a New Workbook for Each Worksheet; Macro 25: Print Specified Worksheets; Macro 26: Protect All Worksheets; Macro 27: Unprotect All Worksheets; Macro 28: Create a Table of Contents for Your Worksheets; Macro 29: Zooming In and Out of a Worksheet with Double-Click; Macro 30: Highlight the Active Row and Column; PART IV: Selecting and Modifying Ranges; Macro 31: Selecting and Formatting a Range; Macro 32: Creating and Selecting Named Ranges

Macro 33: Enumerating Through a Range of CellsMacro 34: Select and Format All Named Ranges; Macro 35: Inserting Blank Rows in a Range; Macro 36: Unhide All Rows and Columns; Macro 37: Deleting Blank Rows; Macro 38: Deleting Blank Columns; Macro 39: Select and Format All Formulas in a Workbook; Macro 40: Find and Select the First Blank Row or Column; Macro 41: Apply Alternate Color Banding; Macro 42: Sort a Range on Double-Click; Macro 43: Limit Range Movement to a Particular Area; Macro 44: Dynamically Set the Print Area of a Worksheet; PART V: Working with Data

Macro 45: Copy and Paste a Range

Save time and be more productive with this helpful guide to Excel macros! While most books about Excel macros offer only minor examples, usually aimed at illustrating a particular topic, this invaluable resource provides you with the tools needed to efficiently and effectively program Excel macros immediately. Step-by-step instructions show you how to create VBA macros and explain how to customize your applications to look and work exactly as you want them to. By the end of the book, you will understand how each featured macro works, be able to reuse the macros included in the book an

Description based upon print version of record.

There are no comments for this item.

Log in to your account to post a comment.