VBA & Macro Problems

Will Excel VBA Macros Become Obsolete? Future Automation Trends

Jason MillerJason Miller Nov 11, 2026 869 views

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.

Will Excel VBA Macros Become Obsolete in the Future?
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 you start

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.

Solution 1Recommended

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.

1
Maintain Existing VBA Scripts

You can continue to safely use and maintain your current VBA macros for desktop-based Excel automation without immediate fear of obsolescence.

2
Manage Macro Security

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.

Security Changes: Recent updates have made running VBA macros stricter. Always ensure your macros are trusted to avoid execution blocks.
Free Microsoft Office alternative

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. 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
  2. 2. Open Your Macro File: Launch WPS Spreadsheet and open your existing .xlsm or .xls macro-enabled workbooks.
  3. 3. Enable Macros: Click 'Enable Macros' when prompted by the security warning to run your VBA scripts flawlessly.
Highly compatible with Microsoft Excel (.xlsx, .xlsm, .xls) formats.Built-in robust support for executing and editing VBA macros.Free to download and lightweight on system resources.Familiar user interface requiring zero learning curve for rapid migration.
microsoft office alternative - wps office

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.