Page 232 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

Tips
• To view all the macros in all open files, select All Open Workbooks from the Macros in drop-down list.
• To be able delete a macro in the Personal Macro Workbook, you need to unhide Personal.xlsb first.
Deleting a macro via Visual Basic Editor
A benefit of using the VBA Editor is that it enables you to delete an entire module with all the macros it contains
in one go. Also, the VBA Editor allows deleting macros in the Personal Macro Workbook without unhiding it.
To permanently delete a module, perform these steps
1 In the Project Explorer, right-click on the module and choose Remove from the context menu.
2 When asked whether you want to export the module before removing it, click No.

To remove a specific macro, simply delete its source code directly in the Code window. Or, you can delete a
macro by using the Tools menu of the VBA Editor:
1 From the Tools menu, choose Macros. The Macros dialog box will appear.
2 In the Macros In drop-down list, select the project containing the unwanted macro.
3 In the Macro Name box, select the macro.
4 Click the Delete button.

219

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