This file contains all the Excel/VBA code from the Office 97 Annoyances book, along with the code from the Excel 97 Annoyances book.

After downloading "Intro to VBA (OfficeAnnoy).xls", opening the file will produce a warning dialog, since the file contains the complete list of macros (procedures) provided in Office 97 Annoyances and Excel 97 Annoyances.

Click the "Enable Macros" button, and you'll notice a spreadsheet that contains the list of macros.

You can navigate to the actual macros by selecting Tools->Macro->Macros (Alt+F8), or for those who want to utilize VBA, by selecting Tools->Macro->Visual Basic Editor (Alt+F11) from the Excel menu.

In order to make "Intro to VBA (OfficeAnnoy).xls" available whenever you start Excel, place the file in the Start Up directory (typically, C:\Program Files\Microsoft Office\Office\Startup), which will make it a global template.

This file contains all the Word/VBA code from the Office 97 Annoyances book, along with the code from the Word 97 Annoyances book.

After downloading "MyMacros (OfficeAnnoy).dot", opening the file will produce a warning dialog, since the file contains the complete list of macros (procedures) provided in Office 97 Annoyances and Word 97 Annoyances.

Click the "Enable Macros" button, and you'll notice a document that contains a table of the list of macros.

You can navigate to the actual macros by selecting Tools->Macro->Macros (Alt+F8), or for those who want to utilize VBA, by selecting Tools->Macro->Visual Basic Editor (Alt+F11) from the Word menu.

In order to make "MyMacros (OfficeAnnoy).dot" available whenever you start Word, place the file in the Start Up directory (typically, C:\Program Files\Microsoft Office\Office\Startup), which will make it a global template.

This PowerPoint 97 file contains a completed ShapeGrabber PowerPoint/VBA utility, including all forms and source code (see "TestShapeGrabber.ppt" for a test presentation).

After downloading "ShapeGrabber.ppt", opening the file will produce a warning dialog, since the file contains macros (procedures).

Click the "Enable Macros" button to open the PowerPoint file.

You can navigate to the actual macros by selecting Tools->Macro->Macros (Alt+F8), or for those who want to utilize VBA, by selecting Tools->Macro->Visual Basic Editor (Alt+F11) from the PowerPoint menu.

Refer to Chapter 4 in Office 97 Annoyances for details on how to utilize "ShapeGrabber.ppt".

This PowerPoint 97 file is a test presentation for use with "ShapeGrabber.ppt".

See Chapter 4 in Office 97 Annoyances for an explanation on how to use TestShapeGrabber.ppt to test the ShapeGrabber PowerPoint/VBA utility.