AutoMacro has been used by employees of these organizations. These organizations do not endorse, approve, sponsor, or otherwise have any affiliation with this website, Spreadsheet Boot Camp LLC, or ToolFive Software LLC.
About the Add-in
Our free VBA add-in installs directly into the VBA Editor (see above).
It contains 150 ready-to-use VBA Macro code examples for Excel. Simply click your desired code example and it will insert directly into your module:
Download
Click the download button to download our free VBA add-in for Excel!
Important! Read the Walkthrough below. It contains important information.
Walkthrough
The macro code examples add-in was designed entirely with VBA. This can be convenient because you don't need to install anything, but VBA has limitations. As a result of these limitations, the add-in will stop functioning periodically (note: this happens when VBA "loses focus", often as a result of code errors).
To help, we built in a "reset" button:
To activate the reset, go to Excel and click the AutomateExcel.com Ribbon > Restore VBA Add-in.
If you find the add-in useful, you'll love our premium VBA add-in (more information below). The premium add-in is not built with VBA and doesn't require any resets. It has many more (better organized) code fragments, VBA code generators, the ability to save your own code, and much more....
Installation
1. Download the file above
2. Follow these directions to install an Excel Add-in.
3. If you encounter an error "Trust access to the VBA project object model is disabled" then you must update the following settings
VBA Add-in FAQs
How to download VBA For Excel?
All versions of Excel already come with VBA installed. Use shortcut ALT + F11 to open the VBA Editor.
How to install Excel Add-ins?
Make sure the Developer Ribbon is installed. Then go to Developer > Excel Add-ins > Browse to select and install your add-in.
What is the VBA Code Examples Add-in?
The VBA Code examples add-in is a free add-in for Excel / VBA that comes with 150+ ready-to-use VBA code examples & macros.
AutoMacro - The Ultimate VBA Add-in
AutoMacro is an add-in that installs directly into the Visual Basic Editor:
The add-in comes loaded with code generators, hundreds of macro code examples, the ability to create your own code library, and other time-saving tools.
Join the Hundreds of Professionals Who Use AutoMacro
"I use it almost every day. A great tool for getting things done, but also a great tool for learning how to do things! This is one purchase this year I have no regrets about."
Galen - USA
AutoMacro Features
Code Generators
Code Generators build code from scratch via visual interfaces!
Code Library
300 Ready-to-use code examples & VBA macros.
Save your own frequently used code and share with team members.
Coding Tools
VBA Coding tools to improve the out of date Visual Basic Editor.
Speed up your workflow with tools to navigate, debug, format and more.
VBA Tutorial
Our premium VBA add-in contains a free VBA tutorial.
Just download AutoMacro and you'll have access to the tutorial.
Why Wait? Order Now
FAQ and Other Information
We have a no-questions-asked, 100% money-back guarantee. If you’re unsatisfied for any reason, let us know and we will refund your order!
Yes! You can download AutoMacro here.
Yes! AutoMacro works in many corporate environments. It was designed to be as unobtrusive as possible and should install without the need for "admin privileges".
AutoMacro is compatible with all versions of Microsoft Office for PCs.
32-bit or 64-bit
Office 2003, 2007, 2010, 2013, 2016, 2019, Office 365, etc.
All Versions of Windows
Surface Pro
AutoMacro is not compatible with Mac operating systems. However, some Mac users running Windows OS are able to use AutoMacro.
If you have doubts, please try the download link above to check.
AutoMacro is not compatible with Citrix environments.
The Beginner version entitles you to a single-use license code valid for 1 computer. The Developer version is valid for 3 computers. The Developer+ allows you to transfer activations between PCs, so that AutoMacro can be activated on any 3 PCs at one time.
Yes! AutoMacro functions in any program with the Visual Basic Editor.
Specific code examples were developed for Excel, Access, Outlook, Word, and PowerPoint.
Join the Hundreds of Professionals Who Use AutoMacro
"Great product, haven’t stopped using it since I purchased it. It doesn’t just write your code, it teaches as you go!"
Tony D - United Kingdom
Steve Rynearson:
Creator of AutoMacro
Over the years, I've spent countless hours searching online for example code and adapting that code to my needs.
I often found myself clicking the same links and copying the same code. I thought there has to be a better way!
AutoMacro is the ultimate VBA Code Helper! It eliminates much of the need to search online for code. Instead simply use the menus to select pre-built code or use the builders to generate code for your exact needs.
Additionally, the coding tools will save you time and help you develop more professional looking code.
For anyone coding VBA, AutoMacro is a life-saver. You'll code much faster, develop more professional code, and learn VBA much faster (if you're not already an expert).