1. Plan and enable a macro. a. Y b. W c. Write out how the macro could be used in a workbook. d. EX 9-Macros in the From the Macro dialog box. Using all of the above. From shortcut key combinations. ou need to plan a macro that enters and formats your name and department in a worksheet, in the range A1:A2. rite out the steps the macro will perform. Start Excel, open a new workbook, then save it as a Macro-Enabled workbook named Hint : The file will have the file extension .xlsm.) location where you store your Data Files. ( e. f. 2. Record a macro. a. b. Name the new macro MyDept Use the Excel Options feature to display the Developer tab if it is not showing in the Ribbon. Using the T rust Center dialog box, enable all macros. Open the Record Macro dialog box. , store it in the current workbook, and enter your name in the Description text box as the person who recorded the macro. c. Sales Department Hint Record the macro, entering your name in cell A1 and : You need to press in cell A2. ( [Ctrl][Home] first to ensure cell A1 will be selected when the macro runs.) d. e. f. g. Resize column A to fit the information entirely in that column. Format the font using Purple from Standard Colors. Add bold formatting to the text in the range A1:A2. Stop the recorder , then save the workbook.3. Run a macro. a. cell B3. b. c. of column A to 8.43. d. Save the workbook. 4. Edit a macro. a. isual Basic Editor. FIGURE 9-20 FIGURE 9-21 Clear cell entries and formats in the range affected by the macro, resize the width of column A to 8.43, then select Run the MyDept macro. Confirm that your name and your sales department are entered in the range A1:A2. On the worksheet, clear all the cell entries and formats generated by running the MyDept macro. Resize the width Open the MyDept macro in the V b. c. d. True to Selection.Font.Bold = False. Use the Close and Return to Microsoft Excel command on the File menu to return to Excel. T Change the line of code above the last line from Selection.Font.Bold = est the macro on Sheet1, click outside the range A1:A2, then compare FIGURE 9-20 e. 5. tcuts to macros. , verifying that the text is not bold. your worksheet to Save the workbook. Assign keyboard shor a. b. c. d. e. Create a macro named DeptStamp in the current workbook, assign your macro the shortcut key combination [Ctrl][Shift][D], Hint : If you get an error when enter your name in the description. ( trying to use [Ctrl][Shift][D], select another key combination.) Begin recording, starting in the current cell of the worksheet. Type Sales Department Save the workbook. sales , format it in bold, italic, and with a font color of green, without underlining. Stop recording. Clear the contents and formats from the cell containing the department text that you used to record the macro. Use the shortcut key combination to run the DeptStamp macro in a cell other than the one in which it was recorded. FIGURE 9-21 . The Sales Department text may appear in a different cell. Compare your macro result to 6. Use the Personal Macro Workbook. a. FitToLand Using Sheet1, record a new macro called and store it in the Personal Macro Workbook with your name in the Description text box. If you already have a macro named FitToLand, replace that macro. The macro should set the print orientation to landscape. b. c. d. e. f. a. b. c. d. e. f. Test data for FitToLand macro in cell A1. After you record the macro, add a new worksheet, and enter Preview Sheet2 in Backstage view to verify the orientation is set to portrait. Run the FitT Save the workbook. oLand macro. (You may have to wait a few moments.) Add your name to the Sheet2 footer , then preview Sheet2 to verify that it is now in Landscape. 7. Assign a macro to a button. Landscape Button Test in cell A1. Add a new worksheet, then enter Using the rectangle shape, draw a rectangle in the range A7:B8. Label the button with the text Landscape Macro worksheet to FIGURE 9-22. , then center and middle align the text. n the macro PERSONAL.XLSB!FitT V Run the FitT oLand to the button. Automating Worksheet Tasks verify that the orientation of Sheet3 is set to portrait. Land macro using the button.

g. h. i. j. FIGURE 9-22 Preview the worksheet, and verify that it is in Landscape. Add your name to the Sheet3 footer , then save the workbook. Click the Developer tab, click the Macro Security button in the Code group, click Macro Settings if necessar y, click the Disable all macros with notification option button to select it, then click OK. oLand Close the workbook, exit Excel without saving the FitT macro in the Personal Macro Workbook, then submit your work- book to your instructor.

Excel