How i can run macro?
There are several ways to run macro:
1 – Click on view tab in main menu in excel window, and then click on macro icon, after clicking on macro icon, macro window will appear.
In macro window choose macro you want to run, then click on run button.
2 – You can make shortcut key to run macro by clicking on Options button in macro window.
Then put character you want to use for shortcut key and click on OK button, it is preferred to put shift and character to avoid conflict with other shortcut keys.
3 – you can click on Developer tab in main menu, if Developer tab not appear in main menu, click on File tab in main menu, and then click on Options tab, excel Options window will open. choose Customize Ribbon tab and select Developer in main tabs by clicking on check box, then click on OK button.
In Developer tab click on Insert tab, and choose Button (Form Control), now put button on sheet, press left button on your mouse then drag the pointer in any direction.
Release mouse button, you will see Assign Macro window, choose Macro you want to run, and click on OK button.
Now you will see button on your sheet, rename it, then click on sheet, any where outside the button, now click on button to run Macro.