Tips, Tricks, and Answers

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

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.