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
   158   159   160   161   162   163   164   165   166   167   168