Page 233 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

How to save macros in Excel
To save a macro in Excel, either recorded or written manually, just save the workbook as macro enabled (*.xlms).
Here's how:
1 In the file containing the macro, click the Save button or press Ctrl + S.
2 The Save As dialog box will appear. Choose Excel Macro-Enabled Workbook (*.xlsm) from the Save as type
drop-down list and click Save.

How to export and import macros in Excel
If you'd like to share your VBA codes with someone or move them to another computer, the fastest way is to
export the entire module as a bas file.
Exporting macros
To export your VBA codes, this is what you need to do:
1 Open the workbook containing the macros.

2 Press Alt + F11 to open the Visual Basic Editor.
3 In the Project Explorer, right-click the Module containing the macros and select Export File.
4 Navigate to the folder where you want to save the exported file, name the file, and click Save.

220

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