|   Home    |    eBooks Home    |    Sample Pages    |
eBooks...

Recording Excel Macros

 

Recording Excel Macros

The Table of Contents below is reproduced from the Recording Excel Macros ebook. You can see a selection of sample pages from the ebook, browse the free extra content, and buy the ebook online by following the links on the left.

Table of Contents

  • About This Book

    • Who is it for?

    • What's Inside?

  • Introducing Recorded Macros

    • What is a Macro?

    • What a Recorded Macro Can Do and What It Can't

    • Visual Basic or VBA?

    • About Macro Security

      • Opening Files Containing VBA Code

      • Setting the Program's Security Level

      • Emailing Files Containing Code

    • Starting and Stopping the Macro Recorder

    • The Visual Basic Toolbar

  • Recording Macros

    • About the Exercises

    • Step-by-Step: Record a Simple Macro

    • Step-by-Step: Test the Macro

    • Step-by-Step: Record and Test a More Complex Macro

    • Tips for Recording Macros

      • Get More Familiar with Excel

      • Plan the Macro

      • Generalize Your Commands

      • Correcting Mistakes

    • Relative or Absolute References?

    • Step-by-Step: Compare Relative and Absolute References

  • Running Macros

    • Different Ways to Run a Macro

      • The Macro Dialog

      • Toolbar Button

      • Menu Item

      • Worksheet Button

      • Graphic Object

      • Assigning a Shortcut Key

      • Automatic Macros

      • Which Way is Best?

    • Undoing a Macro's Actions

  • Macro Options

    • Macro Names

    • Auto Macros

    • Where Should the Macro be Stored?

      • Personal Macro Workbook

      • This Workbook

      • New Workbook

      • Summary and Other Options

    • Changing Macro Options

    • Saving and Deleting Macros

  • Editing Recorded Macros

    • Viewing Recorded Code

      • The Simple Macro

      • The FillEmptyCells Macro

      • The AbsoluteReferences and RelativeReferences Macros

    • The Visual Basic Editor

      • Opening the Visual Basic Editor

      • The Visual Basic Editor Window

      • The Project Explorer

    • Working with VBA Code

      • Managing Code Modules

      • Importing and Exporting Code

      • Running Code from the Visual Basic Editor

      • Editing Code

    • Getting Help

      • Using the Help Menu

      • Context Sensitive Help with the F1 Key

  • Editing VBA Code Practical Exercises

    • Step-by-Step: Experiment with Colours

      • Create the Macro

      • Summary

    • Step-by-Step: Build a Random Numbers Macro

      • Create the Macro

      • Summary

  • What Comes Next?

    • Where Do I Go from Here?

    • Recommended Web Sites

    • Recommended Reading

  • Notes and Further Information

    • About the Author

    • Copyright

    • Limitation of Liability

 

 
^ top
 

Hit Counter