For this assignment, you will be working with macros. Although they might not seem useful at first, macros can actually save a lot of time, especially if you are repeating the same series of steps, such as formatting data, filtering and sorting information, or applying the same series of functions and operations to your sheets.
As a human resources manager at your business, you have been asked to create an address book for all current employees to use for employee-related letters. Your supervisor would like you to create an address book template that could be easily used by departments throughout the company, not just in your human resources department. You decide to create a file with an Address Book template macro that you can share with other departments.
For this assignment, you will apply various security and protections to your AddressBook files you created in Project 1. Macros are great for sharing because macros can be stored in Excel spreadsheets, eliminating the need to send additional files to colleagues. You can simply write a macro, send the spreadsheet over, and let the recipient work with the file on their own. However, the spreadsheet might hold confidential information, so it is important to add layers of security and protections before sharing.