Key Points


  • Macros are handy tools you can use to perform repetitive tasks quickly, such as inserting blocks of text.

  • You don't have to be a programmer to use macros; you can record your actions and have Excel 2007 save them as a macro.

  • Excel 2007 uses macro-enabled workbook types, which have the file extensions .xlsx (a macro-enabled workbook) and .xlstx (a macro-enabled template workbook).

  • If you're curious about what a macro looks like, you can display it in the Visual Basic Editor. If you know a little VBA, or if you just want to experiment, feel free to modify the macro code and see what happens.

  • You can create Quick Access Toolbar buttons and shapes that, when clicked, run a macro.




MicrosoftR Office ExcelR 2007 Step by Step
MicrosoftВ® Office ExcelВ® 2007 Step by Step (Step By Step (Microsoft))
ISBN: 073562304X
EAN: 2147483647
Year: 2004
Pages: 143
Authors: Curtis Frye

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net