Categories

Site Information

 Loading... Please wait...
  • My Account
  • Gift Certificates
  • Image 1

9C_Training

$0.00
Quantity:
The Best Essay Writing Service - EssayBox.org

Product Description

Start Excel. From your student files, open the file e09C_Training. Display the Save As dialog box, navigate to your Excel Chapter 9 folder, click the Save as type arrow, and then click Excel Macro-Enabled Workbook. In the File name box, type Lastname_Firstname_9C_Training and then click Save. To display the Developer tab, click File to display Backstage view. Click Options. In the Excel Options dialog box, on the left, click Customize Ribbon. Under Customize Ribbon, verify that Main Tabs is selected, select the Developer check box, and then click OK. (Mac users, click the Excel menu, and then click Preferences. Under Authoring, click Ribbon &Toolbar.) On the Developer tab, in the Code group, click Macro Security. Under Macro Settings, verify that Disable all macros with notification is selected, and then click OK. (Mac users, click the Excel menu. Click Preferences and then click Security & Privacy.) On the Review tab, in the Protect group, click Protect Workbook. In the Unprotect Workbook dialog box, type goseries which is the password applied to this form, and then click OK. Be sure cell B6 is the active cell. On the Developer tab, in the Code group, click Record Macro. (Mac users, on the View tab, in the Macros group, click the Macros button arrow, and then click Record Macro.) In the Macro name box, delete the existing text, and then type Employee_Section In the Shortcut key box, type t Click the Store macro in arrow, then click This Workbook. Click in the Description box. Type Fills in the Employee section Click OK. In cell B6, type Elaine Richards and then press . With cell B7 active, hold down and press (semicolon), which will insert the current date. Press . With cell B8 active, type Training Click in cell F7 and type Training Specialist and then press . In cell F8, type Westland Electrical and then click cell A11, so that when the macro completes, the first cell in the data area is active to begin filling in the travel information. On the Developer tab, in the Code group, click Stop Recording. Delete the text you just typed in the five cells—B6, B7, B8, F7, F8—and then click cell B6. Then, to test that your macro will fill in the employee information and the date, run the macro by pressing the shortcut key + . Save your workbook. (Mac users, press + + .) On the Quick Access Toolbar, click Customize Quick Access Toolbar, and then click More Commands. Click the Choose commands from arrow, and then click Macros. Click your Employee_Section macro, and then, in the center of the dialog box, click Add. With your Employee_Section command selected on the right, click Modify. Under Symbol, in the seventh row, click the seventh icon—Checkered Square—and then click OK two times. (Mac users, skip this step.) Save your workbook. Select the nonadjacent ranges B6:B8 and F7:F8 and press so that these cells are empty again. Click cell B6, and then on the Quick Access Toolbar, click your new Employee_Section button—the Checkered Square. (Mac users, on the Quick Access Toolbar, click the circle icon.) On the Developer tab, in the Code group, click Macros. Be sure the Employee_Section macro is selected, and then click Edit. In the Code window, at the end of the last line of code—Range(“A11”).Select—click to place the insertion point after Select, and then press . On the new, empty line, type the following code to center the worksheet horizontally and vertically on the page: With ActiveSheet.PageSetup and then press . Press to indent and type .CenterHorizontally = True Press and type .CenterVertically = True and then press . Press + , and then type End With On the menu bar, click File, and then click Close and Return to Microsoft Excel. (Mac users, in the upper left corner of the Microsoft Visual Basic window, click Close to return to your Excel worksheet.) Delete the text in B6:B8 and F7:F8. Click cell B6, and then on the Quick Access Toolbar, click the Employee_Section button that you created, so that the macro runs and includes the centering you added to the macro. Display the Print Preview to verify that the worksheet is centered. Return to the worksheet. Right-click the Checkered Square icon on the Quick Access Toolbar, and then click Remove from Quick Access Toolbar. If you are directed to remove the Developer tab, follow the directions in Activity 9.13. (Mac users, On the Quick Access Toolbar, click Customize Quick Access Toolbar, and then click More Commands. Make sure that Quick Access Toolbar is selected. In the Customize Quick Access Toolbar list, click <>. In the center of the dialog box, click the Remove arrow and then click Save.) Insert a footer in the left section that includes the file name. Display the file properties. As the Tags, type training expense and as the Subject, type your course name and section number. Under Related People, be sure that your name displays as Author. Save and Close your workbook. Submit as directed by your instructor.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Product Reviews

Write Review

This product hasn't received any reviews yet. Be the first to review this product!

Find Similar Products by Category

Click the button below to add the 9C_Training to your wish list.