NC State University Quick Access Toolbar Excel Projects

1-Chapter 9- Project Creation!

For this Project, you will need the following file:

New blank Excel workbook

You will save your workbook as:

Lastname_Firstname_Personal_Footer

Open a blank workbook and save the file as Lastname_Firstname_Personal_Footer. **Make sure to save as a Macro-Enabled Workbook!** Create a professional worksheet of at least five potential employers/businesses that you would like to work for someday. Include name of the business, address, any relevant contact information, and/or current job openings. Format attractively. Then create a macro that adds a footer with your preferred information in the three footer sections. (For example, the macro could add your name in the left footer, your email address in the middle footer, and your contact number in the right footer.) Select a button for the macro, and then assign it to the Quick Access Toolbar. Insert a new worksheet and test your macro. Include the shortcut key in your discussion post, so that we can test it out as well.

Optional: Feel free to add other items to your macro or create another macro for quickly adding formatting, adding contact information in your sheet, etc.

For full credit, review one your classmate’s work. In a reply, provide your classmate with one positive feedback statement (something done well) and one constructive feedback statement (suggestions for improvement, errors, considerations, etc.)

Grading:
75 points for initial post with Excel file attached
25 points for reply to classmate with feedback

Here is a quick video on recording a macro: Using Macros (opens in a new window) (Plain text URL: 2       

 project 2 : 

Open the Excel workbook Student_Excel_9G_Billing.xlsx downloaded with this project. Save the file in your Excel Chapter 9 folder as an Excel Macro-Enabled Workbook.
02Display the Mortgage Chart sheet. Record a macro named Chart_Setup and assign the letter j as the Shortcut key. Store the macro in This Workbook. As the description, type Create footers in chart sheets and then click OK to begin recording the macro.
203On the Page Layout tab, click Margins, and then click Custom Margins. Display the Header/Footer tab, and then insert a Custom Footer on the Mortgage Chart sheet that includes the File name in the left section and the Sheet name in the right section, and then Stop Recording the macro.14Display the Macro dialog box and then Edit the macro code. Click after the apostrophe in the line below the second comment—Create footers in chart sheets—press SPACEBAR, and then type Inserts file name and sheet name 105Close and Return to Microsoft Excel. Add the Chart_Setup macro to the Quick Access Toolbar. Modify the button by changing it to the pie chart—in the second row, the ninth button. If the pie chart button is not available, choose another button.
16Display the Construction Chart sheet, and then use the button you assigned to the Quick Access Toolbar to insert the footer. View the Print Preview to verify that the footer was inserted.
157Display the Summary sheet. Insert three ActiveX Check Box controls positioned at cell B10, B12, and B14 and assign the following properties:

PROPERTY     NAME          CAPTION
CheckBox1  Billing     Billing Verified
CheckBox2  Contact   Contacts Verified
CheckBox3  Manager  Manager Assigned
158Select all three check box controls so that you can modify the following properties at the same time. Change the Height to 18 and the Width to 105 and then change the Font to Bold Italic. With all three check boxes still selected, Distribute Vertically and then Align Left. Turn off Design Mode and then select each check box.
159Remove the pie chart icon from the Quick Access Toolbar. Display the file properties. As the Tags, type billing summary and as the Subject, type your course name and section number. Under Related People, be sure that your name displays as Author. Save your workbook.
810On the Developer tab, in the Code group, click Macros, and then with the Chart_Setup macro selected, click Edit. Select and Copy the four green comment lines beginning with the Chart_Setup Macro line and ending with the Keyboard Shortcut line. Be sure to include the apostrophe at the beginning of the first selected line. Close and Return to Microsoft Excel.