Page 163 - IT_V1.0_Class10
P. 163
The recording will start immediately. As soon as the record macro becomes active a dialog box of
stop recording will be activated.
Step 9: Select the Edit menu from the Menu bar.
Step 10: Select the Paste Special Paste Special option from the submenu. The Paste Special dialog box
opens.
Step 11: Select the Multiply radio button under Operations section.
Step 12: Click on the OK button.
9
11
10
12
The operations specified in macro is applied to the selected cell range(A1:B3).
Step 13: Click on the Stop Recording option.
13
The BASIC Macros dialog box opens, to stop the Macro Recorder and to save the macro.
Step 14: Select the current Spreadsheet. For this example, the current Spreadsheet is Untitled 1.
Step 15: Click on the ‘+’ next to the Spreadsheet to view the contained libraries.
Step 16: Click on the New Module to create a module in the Standard library. If no libraries exist, then the
Standard library is automatically created and used.
Step 17: Click on the OK button to create a module named Multiply.
Step 18: Select the newly created module Multiply.
Step 19: Type the macro name Multiply5 in the Macro Name text box.
Step 20: Click on the Save button.
Using Macros in Spreadsheet 161

