MacroRunner for Excel

MacroRunner is a powerful tool that should be added to everyone`s copy of Microsoft Excel. MacroRunner automates the task of having Excel macros.

Along with automating these tasks, it provides two different ways of automation. In the first customization of automation, a defined function can be inserted into Excel documents that allows for macros to run if a statement is turns as either true or false. You can set certain macros to run if the condition comes back as true and other macros to run if the condition comes back as false. Also, if need be, you can tell the program to specify a value depending on whether the answer comes back as true or false.

In the other customization of automation, macros are activated when certain workbook or worksheet tasks occur. Options for the second customization include - when a workbook is opened, when it`s first activated, when a workbook closes, and when a workbook is deactivated, etc.

MacroRunner is a powerful Excel add-in that enables users to easily automate the process of running Excel macros. MacroRunner provides two methods for automation. One method involves the addition of a user defined function called RunMacro which can be inserted into a worksheet. The RunMacro function works by allowing you to run macros in response to whether a specified condition evaluates to true or false. The second method allows you to run macros in response to several workbook and worksheet related events. With MacroRunner you can take control of when your Excel macros run with no programming involved.
As mentioned above, the RunMacro function allows you to run macros based on whether a condition that you specify evaluates to true for false. The condition consists of comparing two values with a comparision operator (e.g. A1 > 5). You have a number of different options to choose from for each of the two values including a single cell range, a number value, text value, or a value that is returned from another function. You also have several different comparison operator options to choose from including “Begins With” which allows you to specify what set of characters the first value should begin with (e.g A1 Begins With “Bac”) . You have the option of running one macro if the condition evaluates to true and another macro if the condition evaluates to false. In addition to running macros, you can specify that the function returns a value depending on whether the condition evaluates to true or false.
The second method for automating macros is to assign a macro to run in response to an Excel related event. MacroRunner provides several events to choose from including when the workbook first opens. when the workbook closes, when a particular sheet is first activated, and when a particular sheet is deactivated by clicking on it.