Page 227 - IT 402 v2.0 class 10
P. 227
Storing a Macro Internally
When macros are created in Calc, Calc stores the commands in the form of a code. When a macro is run, Calc
executes this code to run the actions saved by the user.
he user can view the command file by following these steps:
Step 1: Click on Tools menu.
Step 2: Click on Macros option.
Step 3: Click on Organize Macros option from the sub-menu.
Step 4: Click on en ce asic option.
Step 5: The en ce asic Macros dialog box will appear on the screen. Click on the macro name.
Step 6: Click on the Edit button.
1
2 3
4
A code window will appear on the screen where the code for the macro can be seen. Note that each macro
starts with the keyword Sub and ends with the keyword End Sub.
Making Macro to Work as a Function
To make a macro that works as a Function, follow these steps:
Step 1: Click on Tools menu.
Step 2: Click on Macros option.
Step 3: Click on Organize Macros option from the sub-menu.
Step 4: Click on en ce asic option.
Step 5: The en ce asic Macros dialog box will appear on the screen. Click on the macro name.
More About Spreadsheet 225

