Page 236 - IT 402 v2.0 class 10
P. 236
3. How Many ways Macro can be Executed? Give steps.
Ans. We can use following three methods to run a macro:
I. Tools Macro Run
II. Use a Push Button
Steps are as follows:
Step 1: Select the View Toolbars Form Controls option.
Step 2: Drag a Button control in any blank cell.
Step 3 Right-click on the button and select the Control option. The Properties: Push Button dialog box
appears.
Step 4: Click on the Events tab.
Step 5: Click on the ellipse (…) button in front of the Mouse button pressed event. The Assign action dialog
box appears.
Step 6: Click on the Macro button. The Macro Selector dialog box appears.
Step 7: Select the macro from Module Library node.
Step 8: Click on OK button. The Assign action dialog box re-appears.
Step 9: Click on OK button.
Step 10: Using the General tab, give a name to the button and keep design mode ON form controls.
Step 11: Now click on the button and find total points on sheet and use same process for sheet .
III. Third method to run a macro is by adding a macro to a Standard toolbar.
Steps are as follows:
Step 1: Select the View Toolbar Customize option.
Step 2: Select the Standard toolbar from a Toolbar drop-down list.
Step 3: Click on the Add button. The Add Commands dialog box appears.
Step 4: Select the OpenO ce Macro Library Module option.
Step 5: Select your macro name.
Step 6: Click on the Add button.
The selected macro is added in the Standard toolbar.
Unsolved Exercise
Section A
(Objective Type Questions)
A. Multiple choice questions:
1. Which menu is used to start track changes?
i. Edit ii. Insert
iii. View iv. Review
2. On which side of the cell, a small triangle appears to indicate changes in a cell?
i. Top left ii. Top right
iii Bottom left iv. Bottom right
3. Which button is pressed to accept every change that has been made in the worksheet?
i. Accept ii. Accept All
iii. Accept Changes iv. Accepted
4. The macros can be accessed from which of the following menus?
i. View ii. Review
iii. Tools iv. Data
234 Touchpad Information Technology-X

