Page 231 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

4 In the Code window, find the target macro, select its code (beginning with Sub and ending with End Sub) and
press Ctrl + C to copy it.
5 In the Project Explorer, find the destination workbook, and then either insert a new module into it (right-click
the workbook and click Insert > Module) or double-click an existing module to open its Code window.

6 In the Code window of the destination module, press Ctrl + V to paste the code. If the module already contains
some code, scroll down to the last code line, and then paste the copied macro.

How to delete macros in Excel
If you no longer need a certain VBA code, you can delete it by using the Macro dialog box or the Visual Basic
Editor.
Deleting a macro from a workbook
To delete a macro directly from your Excel workbook, carry out these steps:

1 On the Developer tab, in the Code group, click the Macros button or press the Alt + F8 shortcut.
2 In the Macro dialog box, select the macro you want to remove and click Delete.

218

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77