Читать книгу Excel Macros For Dummies онлайн

16 страница из 60

Explore ssss1 to find macros that navigate ranges, format cells, and manipulate the data in your workbooks.

If you want to find macros that work with PivotTables, charts, and emails, thumb through the macros in ssss1 where you discover macros that automate redundant PivotTable and chart tasks, as well as macros that send emails and connect to external data sources.

Don’t forget to hit ssss1 for some useful tips and advice on how to get the most out of your new macro skills.

Here are some final things to keep in mind while working with the macros in this book:

 Any file that contains a macro must have the .xlsm file extension. See the section on macro-enabled file extensions in ssss1 for more information.

 Excel does not run macros until they are enabled. As you implement these macros, you and your customers must comply with Excel’s macro security measures. See the section in ssss1 on macro security in Excel for details.

 You cannot undo macro actions. When working in Excel, you can often undo the actions you've taken because Excel keeps a log (called the undo stack) recording your last 100 actions. However, running a macro automatically destroys the undo stack, so you can't undo the actions you take in a macro.