No products in the cart!
Please make your choice.View all catalog
Ever thought to automate things you do in excel? Suppose you are manager of a bank and you are repeating some of the actions on a daily basis. Macros in excel is an action set or a series of actions that you can run as many times as you want. When you create a macro, you are recording your actions i.e. mouse clicks and keystrokes and after the creation of a macro, you can use it as many times you want.
Before you start to use a macro you must know how to record a macro. For recording a macro you must know where to find the developer tab in Microsoft Excel.
Before you create a macro in Excel Macro tools can be found in Excel in Developers Tab To Show the developer tab follow these steps : –
Just Open Excel application for 2010 + versions
For 2007 and earlier versions
Step 1: Just head into the Developer’s Tab
Step 2: Click On the Record Macro under the Developer Tab.
Step 3: You will get a dialog box popup of record Macro. Enter a name suitable for the macro in the Macro name box, enter a shortcut key in the Shortcut key box, and a description in the Description box, and then click OK to start recording.
Step 4: Now perform the actions you want to automate. Then Click on the Stop Recording button. Your macro is now defined well if you want to experiment with your macro and are familiar to Microsoft Visual Basic then follow these steps:
Developer Tab ->Macros-> Edit
Your macro is now created and assigned to a shortcut key if you want to run the macro simply head into the developer’s tab click on macro and select the run option or simply press the shortcut key assigned to it.
Most of the macros are defined in the Excel VBA- Visual Basic for Applications and where lies a an executable there is a security loophole. You can easily trust
A macro virus is a set of one of more macros which set is capable of replicating itself recursively. The set of macros is capable only of copying itself elsewhere once, then it is
not considered to be a virus.
Macros in excel have access to most Windows system calls and executes automatically when workbooks are opened since they are pieces of code and there is a potential threat of the existence of a virus written as a macro and is hidden within Excel that are executed on opening a workbook.
Excel workbooks with macros are saved with .xlsm file extension but yeah extentions with.xlsx do not hold any macros within therby are safe. They are termed as Macro Enabled Excel Workbooks. Before you open such workbooks, you should make sure that the macros they contain are not malicious.
A macro virus can be spread through e-mail attachments, removable media, networks and the Internet, and is notoriously difficult to detect. A common way for a macro virus to infect a computer is by replacing normal macros with a virus. The macro virus replaces regular commands with the same name and runs when the command is selected. These malicious macros may start automatically when a document is opened or closed, without the user’s knowledge.
Step 1: Just head into the File Tab
Step 2: Select Options
Step 3: The excel options dialog box appears. Select the Trust Center in the left pane.
Here you can choose the permission level for macros such as