Macros

Tips, Tricks, and Answers

The following articles are available for the 'Macros' topic. Click the article's title (shown in bold) to see the associated article.

Calculating Just the Active Workbook
When you enter information into a workbook, Excel automatically recalculates every worksheet in every open workbook on your system. If you want to limit what is recalculated, you'll need some of the techniques described in this tip.

Displaying Excel's Developer Tab
The Developer tab of the ribbon is the gateway to many advanced features in Excel, including those features related to working with macros. The Developer tab is not visible by default in Excel, but here's how to make sure it remains displayed on your system.

Running a Macro when a Worksheet is Activated
Need Excel to run a particular macro whenever a worksheet is selected? It's easy to do, as you'll discover in this tip.

Running a Macro when Deactivating a Worksheet
When you change from one worksheet to another, you may want to have Excel automatically run a macro for the worksheet you are leaving. You can easily create such a macro by using the Auto_Deactivate event.