Automating tasks

Makra — information

 If some tasks are repeated in programme Microsoft Excel often, it then was can automate their executing for help of macro. The macro is the series of recommendations and the function ( the function: Previously written formula, which takes the value or the value, it carries out the operation and the value pays back or the value. the Functions simplify and the used in sheet formulae shorten particularly these which carry out long or the folded calculation.) kept in module ( the module: Collection of declaration, instruction and the procedures which be kept as named individual together. two types of modules: standard modules Exist and the modules of classes.) the language the Microsoft the Visual the Basic and it can be started always, it when was one should execute the data of task. < BR > On example if long textual draughts to cells be introduced often, it then was can create macro so formatting cells, to being in them text be wrapped up. < B > Recording macros During recording macro programme Excel keeps about every executed by using the series of recommendations user step information. It it was can was then start macro, to repeat or "reproduce” recommendation. After they commissions the mistake during introduced by user recording the macro of correction they are recorded also. The language the Visual the Basic ( the Visual the Basic: Language of programming of high level the being the visual version of language Basic. the Language the Visual the Microsoft the Basic was worked out through firm and the Windows serves to building the application of system.) every macro keeps in new added to file module. It < B > Configuration macro , it to was can was it it was easily it Can started was starting macro, choosing it with letters displayed in dialogue window Macro. To the macro started after clicking of definite button always or the pressing the combination of keys we can attribute it to button of belt of tools, the key of shortcut ( the key of shortcut: Key of function or the combination of keys, on example F5 or the CTRL + And, which it was can use, to executing the recommendation of menu. In distinction from him the key of access is the combination of keys on example the ALT + the F which transfers on menu fokus the recommendation or the formant.) or the graphic placed in sheet object. It < B > Management macros it After macro was registering was can look through his code, using Editor Visual Basic (Editor Microsoft Visual Basic: Environment, in which we can edit registered macros as well as write new macros and programmes in language Visual Basic for Applications.) in aim correcting mistakes or executed altering action by macro. was On example if wrapping up in cell text macro has him to thichen also, it then was can register macro servants to thichen text, and to copy to wrapping up in cell text macro his instructions then. The editor the Visual the Basic then the programme which became designed so, to to facilitate writing down and the editing the code of macros the novice users and to assure in online mode the spacious Help. To to introduce in macros the straight lines of change, we should not know the methods of programming nor the using of language the Visual the Basic. Using with Editor to copy Visual Basic we, can edit macro, it from one module to different, to copy from one file macro to different, to alter name modules in which they be kept macro or to alter the name of macros. the Safety of macros the Programme the Excel assures in protection the help before viruses ( the virus: computer Programme or the macro, which " it infects” the computer files by introduction to these files its copy. When the the plague - stricken file be becomes loaded to memory, the virus can infect different files. the Viruses have the harmful side effects often.), which they can be transferred in macros. It was can sign for help of digital signature available different users macros ( digital: Electronic, coded signature, safe "stamp”, which authenticates macro or document. Signature this confirms that macro or document comes from from person which signed him, and he did not become after road altered.), to they could check they, that macros come from from credible source. Every time during unlocking the file of including macro can verify the source of origin of macros before inclusion of their.
< TD > < OL >
  • Unlock including macro which file you want to remove.
  • In menu of Tool show recommendation Macro, and click the recommendation of Macro then.
  • On letter of Macro in click the position This file.
  • In field the Name of macro click name macro, you which want to remove.
  • Click button Remove.
    • Copying to different file the module of macro
    1. the Laws the level of protections on Average.
    2. In menu of Tool click recommendation Options.
    3. Click the card of Protection.
    4. In area of Protection of macros click button the Safety of macros.
    5. Click card the Level of protections, and choose the demanded level of protections then.
    6. Unlock the file the including module ( the module: Collection of declaration, instruction and the procedures which be kept as named individual together. two types of modules: standard modules Exist and the modules of classes.), which want to copy and the file to which want him to copy.
    7. In menu of Tool show recommendation Macro, and click recommendation Editor Visual Basic then.
    8. In menu View click recommendation the Explorator of project .
    9. Pull module you which want to copy, to target file.
    Creating macros
    1. In menu of Tool of programme Microsoft Excel show recommendation Macro, and click recommendation Editor Visual Basic then.
    2. In menu Put in click recommendation Module.
    3. Write or copy to window of code suitable code in module.
    4. Wanting starting from window of module macro, press key F5.
    5. click After end of writing of macro in menu File recommendation Close and return to programme Excel.
    Removing macro
    Editing macro
    1. Laws Average or Low level protections.
    2. In menu of Tool show recommendation Macro, and click the recommendation of Macro then.
    3. In field the Name of macro introduce the name of macro.
    4. Click button Edition.
    Starting macro
    1. Laws Average or Low level protections.
    2. Unlock including Macro file.
    3. In menu of Tool show recommendation Macro, and click the recommendation of Macro then.
    4. In field the Name of macro introduce name macro, you which want to start.
    5. Click button Start.
    Stop macro
    • If you want to stop acting macro at present ( the macro: Action or the set of action we which can use to automation of tasks. the programming the Macros be recorded in language the Visual the Basic the for the Applications.) press the key the ESC, and click the button the End in window the dialogue Microsoft the Visual the Basic then.
    • If you want to prevent automatic starting macro during starting programme Microsoft Excel, hold key SHIFT during starting.
    Main side Help and instructions