ERLANDSEN DATA CONSULTING Excel & VBA Tips   Informasjon på norsk / Information in Norwegian

Valid HTML 4.01 Transitional

These pages are no longer updated and are only available for archive purposes.

Click here to visit the pages with updated information.

Document: Description: Sort by date
Add a procedure to a module You can add code to a module without using a separate text file that contains the code. 2000-02-05
Add content to a module from a file You can add procedures to an existing module, add the content of a text file to an existing module. 2000-02-05
Change the worksheet codemodule names Useful macro for changing the worksheet codemodule names in the VBProject. 1999-12-20
Check if a VBProject is protected This function lets you check if a VBProject is protected before you try to edit the project. 2000-02-05
Copy a module from one workbook to another This macro can be used to copy a module from one workbook to another 2008-04-26
Create a new module How to create a new macro module in a workbook. 2000-02-05
Delete a module How to delete a module from a workbook project. 2000-02-05
Delete a procedure from a module How to delete an existing procedure from a module. 2000-02-05
Delete all macros in a workbook/document How to delete all macros from an Excel workbook or a Word document. 2002-07-17
Delete module content You can't delete the codemodules for worksheets, charts and ThisWorkbook. In these modules you have to delete the content instead of the module itself. 2000-02-05
Grant your code access to the VBProjects In Excel 2003 or later you have to give your code access to the VBProjects. 2006-05-16
Insert a new module from a file The easy way to insert new modules with contents in a workbook project. 2000-02-05
Restore the VBE windows to their default positions If you have trouble with the docking of the different VBE windows, you can restore their positions by editing a setting in the Registry. 2000-02-05
Erlandsen Data Consulting   
Excel & VBA Tips   Copyright ©1999-2017    Ole P. Erlandsen   All rights reserved
E-mail Contact Address