Activating the Ribbons Developer

If you'll be writing VBA code regularly, you can make some coding chores a bit more efficient by displaying the new Developer tab in the Office 2007 Ribbon. This tab gives you one-click access to many VBA-related features, so it's worth displaying. Follow these steps:

1. Choose Office, Application Options (where Application is the name of the current Office program, such as Word or Excel).

2. In the Popular tab, click to activate the Show Developer Tab in Ribbon check box.

Note that displaying the Developer tab in one Office program displays it in all of them. Figure 2.1 shows the Developer tab displayed in Excel.

Figure 2.1

Display the Developer tab for easier access to some VBA features.

Figure 2.1

Display the Developer tab for easier access to some VBA features.

0 0

Post a comment