Ch.14--"Macros, Macros, Macros"

Chapter 14 is all about macros – how to create and use them. To create a new macro, go to the tools menu and then click on macros and select record new macro. For macro name just name the macro the way you wish. In description put what it does and for shortcut key type in a letter a-z and don’t use a key that already has a shortcut. Now click ok and then while the macro is recording do what you want it to do. Whether that is to create a new row or add up a column. Then hit the stop recording button and to use the macro just hit your shortcut key that you assigned earlier. To edit them go to tools macro and macros. When the code pops up you can add or delete what you want. To add something you must type “Selection.Font.Bold = True” is an example.

The first project wants you to create a macro that inserts a column. I just followed the steps I did above except I named it InsrtCol. I ran the macro and it worked. The second project asks you to edit a macro that is already created. I edited it by typing Selection.Font.Bold = True and Selection.Font.Italic = True. The activity wants you to create a macro that totals the columns. I did the same steps as before, but when I was recording it I went under a column and put in the sum formula to total the column. I used the macro to extend it to all columns.