Topic: Managing Macros

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

Aborting a Macro and Retaining Control If you need to exit a macro before it is finished running, you can do it using a brute force method, or you can build in a way to gracefully exit. This tip discusses the latter way to get out of a macro and still retain a modicum of control. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Automating Copying Macros If you’ve ever tried to copy macros from one workbook to another, the experience can be frustrating. Here’s how to do the copying with a minimum of fuss. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Clean Up Your Macro List Over time you may accumulate a whole collection of macros you no longer need, particularly if those macros were created for only one or two uses. You can help keep your Excel environment clean and tidy by deleting these unneeded macros periodically. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Disabling Shift Key Use when Opening a Workbook Open up a workbook, and Excel normally runs the macros associated with that workbook. You can disable the automatic running of macros by holding down the Shift key while the workbook opens. If you want to defeat this ability, you may be out of luck. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Generating a List of Macros Creating a macro to compile a list of macros in an Excel workbook. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Hiding Macros Macros are normally visible if you take a look at the Macros dialog box. There are ways you can make sure they are not included in the dialog box, and the methods only take a small change or two. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

List of Macro Shortcuts in All Open Workbooks Need a list of macro shortcut keys? It’s not as easy in Excel as in some other Office applications, such as Word. It can be done, however, with a little ingenuity, as described in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

One Shortcut for Two Macros Macros and the shortcuts used to invoke those macros are stored on a workbook-by-workbook basis. If you load two workbooks, each of which uses the same shortcut to run a macro, the results may seem unpredictable. This tip explains how Excel deals with the conflicting shortcuts and how you can work around the apparent conflict. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Opening Personal.xlsb in Excel 2007 If you start up Excel 2007 and all you see is your Personal.xlsb file, then you may wonder what you are doing wrong. The answer is nothing—all you need to do is make sure that the file is hidden, as discussed in this tip. Microsoft Excel versions: 2007

Recovering Macros from Corrupted Workbooks Corruption of a workbook can cause data loss. Sometimes it is a bigger problem to lose macros than it is to lose data. Here’s a couple different ways you can attempt to recover macros trapped inside a corrupted workbook. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Removing a Directory When writing macros, you may have the need to remove a directory that you previously created. You can use the RmDir function, described in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Renaming a File Need to rename a file in a macro? It’s easy to do using the Name command, as discussed in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Transferring an Older Personal.xls to Excel 2007 As you update your computer equipment, it is not unusual to also upgrade to a newer version of your software. With Excel, this may mean updating some of your older customizations to work with the newer system. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Tips, Tricks, and Answers

An Amazing Resource!

Helpful Links

Great Info!

RSS Feeds