Easily add a double-sided Print button to Excel 2007

As you know, you can print odd-numbered pages and even pages separately in Word to achieve a duplex effect on multi-page documents. However, this feature is not in Excel. Let's take the Excel2007 as an example and add a button with the duplex feature.

First, expand the Development Tools tab

To implement duplex printing in Excel, you will need to use its embedded VBA features, so you'll want to expand the Developer tab first.

Start Excel2007, click the Software icon in the upper-left corner, and in the Drop-down menu that appears (Figure 1), select the Excel Options option to open the Excel Options dialog box (Figure 2).

Figure 1 Drop-down Menu

Figure 2 Excel Options dialog box

First select the Personalization option on the left, and then select the Show the Developer tab in the Ribbon to determine the return on the right-hand side, "Use Excel with Preferences" below.

Second, generate "Personal Macro Workbook"

To make the duplex button work for all workbooks, we need to save it in the Personal Macro workbook. The first time you use the macros feature, you need to have the software generate a hidden personal macro workbook.

Switch to the Developer tab, click the Record Macro button, and open the Record New Macro dialog box (Figure 3). Enter the name of the macro (such as "Smdy"), press the Drop-down button on the right of "save on", and in the Drop-down list that appears, select the Personal Macro Workbook option to determine the status of the macro recording.

Figure 3 Recording a new macro

You don't need to do anything, just click the Stop Recording button on the Developer tab and the system automatically generates a hidden personal macro workbook.

Special reminder: When you need to edit macros in your personal macro workbook, you don't need to go into this step again.

Third, edit the "double-sided printing" code

Click the Visual Basic button on the Developer tab to enter the VBA editing state (Figure 4).

Figure 4 Entering the VBA edit state