Prevent that an automacro/eventmacro executes using VBA in Microsoft Excel

If you wish to open a workbook without running an Auto_Open-macro, you can do this by holding the Shift-key down when you open the file. If the wo...

Chart object events using VBA in Microsoft Excel

If you want to write event procedures for an embedded chart, you will have to create a class module to do this: Start the Visual Basic editor. Select...

Class modules using VBA in Microsoft Excel 2010

A class is the formal definition of an object. The class is a template for the creation of the object during programming, and defines the properties ...

Create eventmacros for the Application object using VBA in Microsoft Excel

Start the Visual Basic editor. Select the desired project in the Project-window. Insert a new class module by selecting the menu Insert | Class Modu...

Import a module from a file using VBA in Microsoft Excel

In this article, we will create a macro to import a module to the active workbook. We will be using Filename.bas as a module, which we want to import...

Delete module content using VBA in Microsoft Excel

It's not possible to delete all kinds of modules, you can't delete the codemodules for worksheets, charts and ThisWorkbook. In these modules you have...

Delete all macros in a workbook/document using VBA in Microsoft Excel

If you are working with countless macros & you want a macro to erase all the existing codes from the current excel workbook then the following art...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube