Will Excel VBA Macros Become Obsolete? Future Automation Trends
Question details
The user wants to know if Microsoft plans to deprecate or discontinue VBA macros in Excel, and how to approach future automation projects.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Evaluating the longevity of VBA for building and maintaining Excel automation workflows.
- Observed behavior
- Users are noticing Microsoft's push towards modern tools like Office Scripts and Python, along with tightened VBA security policies, raising concerns about VBA's lifespan.
Before transitioning away from VBA or building new complex macros, identify whether your automation needs require cross-platform support (web/mac) or heavy data science integrations.
Understanding the Current Status of VBA in Excel
Learn why VBA is not disappearing immediately but is shifting in focus.
VBA remains a core automation technology in Excel and is highly unlikely to be discontinued in the near future. Microsoft is committed to maintaining it to ensure compatibility with millions of legacy workbooks globally.
However, Microsoft is not actively adding major new features to VBA. Instead, recent updates focus primarily on tightening security, such as the February 2023 update that made working with XLSM files stricter by blocking untrusted macros by default.
You can continue to safely use and maintain your current VBA macros for desktop-based Excel automation without immediate fear of obsolescence.
Ensure your macro-enabled files (.xlsm) are stored in Trusted Locations or are digitally signed, as modern Excel versions block unverified macros downloaded from the internet.
Evaluating Modern Automation Alternatives
Consider newer technologies like Office Scripts and Python for future-proofing new projects.
Enjoy Seamless VBA Compatibility with WPS Office
Looking for a cost-effective alternative that still supports your legacy VBA macros? WPS Office provides excellent compatibility with Microsoft Excel's VBA environments, ensuring your automated workflows keep running smoothly in a lightweight, modern interface.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
- 2. Open Your Macro File: Launch WPS Spreadsheet and open your existing .xlsm or .xls macro-enabled workbooks.
- 3. Enable Macros: Click 'Enable Macros' when prompted by the security warning to run your VBA scripts flawlessly.

Frequently Asked Questions
Can I use VBA macros in Excel on the web?
No, VBA macros are only supported in the desktop versions of Excel for Windows and Mac. For web-based automation, you must use Office Scripts.
Why did my VBA macros suddenly stop working in Excel?
Microsoft introduced stricter security measures in early 2023, blocking macros originating from the internet by default. You need to unblock the file in its Properties or move it to a Trusted Location.
Should I learn VBA or Python for Excel today?
It depends on your goals. Learn VBA if you need to maintain legacy enterprise systems or automate desktop Excel UI tasks. Learn Python if your focus is data analysis, statistics, or machine learning.
Will my old .xlsm files stop working soon?
No, Microsoft will continue to support the .xlsm format and VBA execution for the foreseeable future to maintain backward compatibility with millions of existing enterprise workbooks.




