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.
Below you will find two download links for the 64-bit and 32-bit versions of AutoMacro. You need to download the software version that matches your Microsoft Office installation (Not your Windows Installation!). To check which version you have installed, follow these directions. If you install the wrong version, the add-in will not work.
To install the software follow these steps:
1. Click the download link above. Important! Make sure you download the version that corresponds to your Office installation (See these directions to determine which version you have)
2. Close All Microsoft Office Programs (Excel, PowerPoint, Word, Outlook, etc.)
3. Click the AutoMacro downloaded file in your browser (see image below) or navigate to your download folder and double-click the MSI file.
You may see a warning message. This is a standard Windows warning message that appears when trying to install software from smaller software publishers. You can ignore it and click "run" or "install". If you are running Windows 10 (or possibly other versions), you may need to click "show more" before the "run" option appears.
4. Open Excel and go to the Visual Basic Editor (shortcut ALT + F11)
5. You will be prompted to enter a license code. If you purchased a full license, you will receive an email from Shareit.com with the license code.
Enable / Disable
Once you install the software, you can easily enable or disable it from the Visual Basic Editor (VBE).
1. Open the VBE
You can use the shortcut ALT + F11 to open the VBE or navigate to the Developer Ribbon Tab and click "Visual Basic" (If you don't see the Developer Ribbon Tab follow these directions).
1. Open the Add-in Manager from the VBE Toolbar
2. Select the AutoMacro add-in and choose your desired settings.
If 'Loaded/Unloaded' is checked, the add-in is active. If you uncheck it, then the add-in is disabled. If 'Load on Startup' is selected, then the add-in will automatically load on startup. For the add-in to function properly, make sure both checkboxes are checked.
It's easy to completely uninstall AutoMacro from your computer.
1. Go to Windows > Control Panel
2. Go to 'Uninstall a Program'
3. Find 'AutoMacro', right-click on it, and choose uninstall.
Do you see an error message?
Do you see an error messages when attempting to load the VBA Editor?
If you see an error message, most likely you did not install the correct version of AutoMacro. Please verify you installed the correction version.
If you verified that you installed the correct version. Most likely there was an issue registering AutoMacro to your computer during the installation. Please download this zip file, unzip it, and run the version corresponding to your Office bit-version. If possible, please try to "Run as Administrator" by right-clicking on the .BAT file (This is required for some users to fix the problem).
AutoMacro Is Not Visible
If you open the VBA Editor and don't see AutoMacro's toolbars. Click Add-ins > Add-in Manager. Do you see AutoMacro Listed?
If not, Excel might be running as Administrator, preventing the add-in from loading.
To check if Excel is running as Administrator, follow the steps here.
To set Excel to not run as Administrator, follow the steps at the bottom of this page.
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
Code Generators build code from scratch via visual interfaces!
200+ Ready-to-use code examples.
Save your own frequently used code and share with team members.
VBA Coding tools to improve the out of date Visual Basic Editor.
Speed up your workflow with tools to navigate, debug, format and more.
Why Wait? Order Now
Simple version for beginners
1 User - 1 PC
Tools for serious developers
1 User - 3 PCs
Tools for serious developers & more
1 User - 3 Transferable PCs & Updates
One-time fee + $20 Annual (starts in 1 year)
FAQ and Other Information
What is your refund policy?
We have a 30-day, no-questions-asked, 100% money-back guarantee. If you’re unsatisfied for any reason, let us know and we will refund your order!
Can I try AutoMacro before I buy?
Yes! You can download AutoMacro here.
Can I install AutoMacro on my Work Computer?
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".
Will AutoMacro work on my system?
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
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.
Can I deduct this purchase on my taxes?
See this page from the IRS on Employee Business Expenses.
Can I use on more than one computer?
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.
Does AutoMacro work with PowerPoint, Word, or Access?
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
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).