Remove VBA Line Numbers Add-In for MS Access

This 100% FREE Microsoft Access Add-In tool is designed to help you remove all of the VBA line numbers in your VBA project with a single button click. I've also provided a standalone VBA subroutine to remove all line numbers from all code files in a VBA project, in case it's needed for one of the other MS Office apps aside from Access, like Excel or Word.

Where to Download:

Download the 'Remove VBA Line Numbers' Add-In (.accda file) for MS Access: Latest ACCDA Download

Or view/download the latest Stable Release package: Latest Full Release Package

Or view the VBA code used in this tool here: VBA Code to Remove Line numbers

How to Install:

To just install the latest version of this Access Add-In without messing with any of the source code, complete the following steps:

1. Download the latest ACCDA file from HERE.
2. Open any database in Microsoft Access and go to the "Database Tools" Ribbon menu.

3. On the "Database Tools" Ribbon, click the "Add-Ins" option drop down, and choose the "Add-In Manager" option.

4. The Access "Add-In Manager" form will be opened, click the "Add New..." button.

5. The Access "Open" file dialog will be opened.

6. On the "Open" file dialog, navigate to the ACCDA file you downloaded and click the "Open" button.

7. The Add-In will be installed and will now show in the "Add-In Manager" form.

The 'Remove VBA Line Numbers' Add-In should now be installed correctly.

How to Use this Tool:

To use this tool once it has been installed:

1. Open the Access database you want to remove the VBA line numbers from in Microsoft Access.
2. On the "Database Tools" Ribbon, click the "Add-Ins" option drop down, and then choose the "Remove VBA Line Nums" option.

3. The "Remove VBA Line Numbers" tool form will open. To remove all the line numbers in the currently opened database, click the "Remove VBA Line Numbers" button.

All line numbers from your VBA project will be removed and replaced with spaces.

Project Contributors:

A GREAT BIG THANKS to the following contributors to this project:

1. The MS Access MVP Group - For inspiring this tool.

2. Geoffrey Griffith - For his work to create this 100% Free tool for Microsoft Access.

Other Free Microsoft Access Tools:

Some other projects I've created in MS Access that I've also made available 100% for FREE:

1. Access Add-In Helper

2. Microsoft Access Database Property Editor Add-In

3. Win32 API Declarations for VBA