Excel20 10 how to print a double-sided training demand questionnaire
Double-sided printing means that after printing on one side of the paper, the printer completes a turnover inside it and sends it back to the paper feed channel to finish printing on the other side. In order to save paper, users can record new macros and print "Staff Training Needs Questionnaire" on both sides. 1. Select the option command, click the File button, and then select the option button in the pop-up drop-down list. 2. Select the custom ribbon option to open the Excel Options dialog box, select the custom ribbon option on the left, and then select the development tool check box on the right. 3. Record Macro Click OK to return to the worksheet, switch to the Developer tab, and then click Record Macro. 4. Set the macro name and save location to open the Record New Macro dialog box, enter the training requirements in the Macro Name text box, select the Personal Macro Workbook option in the Save Location drop-down list, and then click OK. 5. Click the Stop Recording button to return to the worksheet, and then click the Stop Recording button in the Code Group. At this point, the personal macro workbook will be created. 6. click the VisualBasic button. Click the VisualBasic button in the code group. 7. Double-click the VBAProject (PERSONALXLSB) option to open the VisualBasic editor window, where you can find VBAProject (PERSONAL). XLSB) option and double-click. 8. Double-click the module 1 option. Click the expand button on the left side of Module in the pop-up drop-down list, and then double-click Module 1 in the pop-up list. 9. Check the code of module 1 and "Personal" will pop up. XLSB- module 1 (code) "dialog box, and then you can see the Personal Macro Workbook just established. 10. Enter the code that defines printing. Enter the code to be printed in Personal. XLSB- module 1 (code) "dialog box. 1 1. Click the Save button, and then click the Save button in the VBA window toolbar. 12. Click the Macro button to return to the worksheet, and then click the Macro button in the Code Group. 13. Click the Execute button to pop up the macro dialog box, where you can see the macro you just set. Click the execute button. 14. Click "OK" to pop up the "Print the other side" dialog box, prompting the message "Please load the printing paper backwards into the paper slot", and click "OK".