AutoMacro - Introduction

AutoMacro installs four ToolBars directly into the Visual Basic Editor:

automacro vba addin

  1. Code Tools & Utilities - Tools to navigate, format, edit, and debug code.
  2. VBA Code Library - 230+ Pre-built code fragments. Ready to insert into your project.
  3. Code Builders - Quickly generate complex code from scratch with virtually no coding knowledge required.
  4. Custom Code Library - Add your own code, organize into folders, and share with team members.


The Settings menu is located in the VBA Tools ToolBar:

settings toolbar

settings menu

  1. Note: This setting has now been moved to the "Edit" Menu in the 'Custom Code' Toolbar You can change the location of the "Custom Code" folder that stores your code. You can change the location to a location on a shared network drive and share code with your coworkers.
  2. AutoMacro has two primary settings when inserting code containing objects:
    1. Read the currently active workbook, worksheet, and/or range. Hard-code them directly into code (ex. worksheet("sheet1"), range("b5") )
    2. Insert object variables corresponding to the workbook, worksheet, or range (ex. ws, wb, rng)
  3. Adjust the variable names used if option 2 is checked.
  4. When using the Code Indenter Tool, do you want to start at 0 indent or 1 indent:

0 Indent

code indent 0

1 Indent

code indent 1


The Help menu is located in the VBA Tools ToolBar:

help toolbar

License Details

Here you will find information about your license.

You will be able to deactivate a license so that you can use it on another computer, check for software updates, and upgrade.

Last modified 3 years ago.

^ Top