pls follow instructions
W7-FB21
| Wednesday Report | |||||||
| Prepared by: | |||||||
| Today’s Date: | |||||||
| Visitor Name Last, First |
Admin Assistant to Contact | Company Sponsor: | Expected Arrival Time | Duration in Hours | Security Clearance Badge | Visitor’s Company Affiliation | Reason for Visit |
| Crowley, Jim | Allison | Kiola Taylor | 9am | 2 | Escort at All Times | RJ & Associates | Product supplier meeting |
| Dyko, Alexander | Carmen | Paul Gomez | 9:30am | 4 | No Escort | TheZone – Europe | TZEdge Product Meeting |
| Joshi, Shantanu | Carmen | Paul Gomez | 11:30am | 6 | No Escort | TheZone – Asia | TZEdge Product Meeting |
| Kane, Jones | Carmen | Paul Gomez | 11:40am | 4 | No Escort | TheZone – Europe | TZEdge Product Meeting |
| Kelly, Jacob | Tisha | HR approved vendor | noon | 2 | Escort in Restricted Areas | CC Water | Delivery |
| Watts, Lynn | Tisha | HR approved vendor | 2pm | 3 | Escort in Restricted Areas | Watts Design | Meeting w/Building Services |
| Zhang, Qi | Carmen | Paul Gomez | 3:30pm | 6 | No Escort | TheZone – Asia | TZEdge Product Meeting |
| FNU-A |
1
WEEK # 7 – EXERCISES CHAPTER # 10
Exercise Ch10-1: Level 3- Daily List.
One of Kiola’s colleagues in HR uses an Excel worksheet to keep track of daily information regarding
appointments and visitors expected at the company’s campus. Each morning this information is
printed and distributed to each of the receptionists and administrative assistants. The receptionists
are given one version and the administrative assistants another.
Kiola’s colleague would like your help in creating a macro to print out the worksheet in the two
required formats. To make it easy for anyone to produce the appointment and visitor lists, HR would
like the capability of launching the macro from a shortcut key sequence, a macro button on a custom
ribbon tab, and a custom button directly on the worksheet.
1. Open the workbook named WednesdayReport.xlsx attached with the data of the assignment,
and save the file as the macro-enabled workbook 10-1-DailyList-Wednesday-
YourName.xlsx.
If the DEVELOPER tab is not already visible, add it to the ribbon.
TROUBLESHOOTING: In order to complete this step, the macro settings on your
computer must be enabled. If you receive a Security Warning saying macros have been
disabled or the file can’t be saved as a macro-enabled workbook, open the Trust Center
to check the macro security settings. If you don’t have access to the Trust Center,
contact your instructor or computer support person for assistance.
2. Enter your name and current data in the cells highlighted in yellow.
3. Plan the macro steps and then record the macro, naming it MacroWednesdayPrintOut, and
saving it in the current workbook. Assign the macro to the Ctrl+Shift+F shortcut key combination.
Enter a description for the macro. Perform the following steps while recording the macro:
• Change “Wednesday Report” header with the header with “Visitors – Admin List” in the top
center and page number on the top right. Merge to Center
• Change the grey titles to other color
• Save as pdf and select as File Name 10-1-DailyList-Wednesday-YourName-
Result.pdf
4. Run the macro to test it. If it does not perform all the tasks you planned, re-record the macro using
the same name.
(Hint: You must enter a new shortcut key because Ctrl+Shift+F has already been assigned to the
first macro you recorded.)
5. Add a custom button with the label WEDNESDAY BUTTON to run the macro. Place it at the top
of the worksheet close to your name.
6. Save the workbook, and then test the macro buttons.
7. View the code in the Visual Basic Editor. Copy the code starting from the beginning (Sub) until the
first End With statement. (Hint: Select the code to highlight it and then use Ctrl+C to copy the code
to the Clipboard.) Exit the VBA Editor, and then paste (press Ctrl+V) the code onto a new worksheet
named MACRO-WEDNESDAY-CODE.
9. Save and close the 10-1-DailyList-Wednesday-YourName.xlsx workbook.
