How to Record VBA Macros Instead of Office Scripts in Excel
Question details
The user needs to record a traditional VBA macro, but the Excel application is defaulting to recording an Office Script instead.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to record automation steps using the Excel ribbon interface.
- Observed behavior
- Excel utilizes the Automate tab to record Office Scripts rather than providing the traditional option to record VBA macros.
Ensure you are using the desktop version of Excel, as VBA macros are not supported in Excel for the Web. Additionally, check if your organization's IT policies allow VBA macro execution.
Enable the Developer Tab to Record VBA Macros on Windows
By displaying the hidden Developer tab, you can access the traditional 'Record Macro' feature for VBA instead of Office Scripts.
Excel has separate automation systems: VBA macros and Office Scripts. The Automate tab is strictly for Office Scripts, while VBA tools are housed in the Developer tab, which is hidden by default.
Launch Excel, click on the 'File' menu in the top-left corner, and select 'Options' at the bottom of the menu.
In the Excel Options dialog box, select 'Customize Ribbon' from the left-hand navigation pane.
In the right pane under 'Main Tabs', locate and check the box next to 'Developer', then click 'OK' to save your changes.
Navigate to the newly added 'Developer' tab on your ribbon and click 'Record Macro' in the Code group to start recording a VBA macro.
Show the Developer Tab to Record VBA Macros on Mac
Excel for Mac requires a slightly different process to reveal the Developer tab for VBA macro recording.
Enjoy a Classic Interface and Full VBA Support with WPS Office
If navigating Excel's changing menus between Office Scripts and VBA is frustrating, try WPS Office. It provides a classic, intuitive interface where Developer tools and traditional VBA macros are easy to find and use. Best of all, it is completely free and highly compatible with Microsoft Office formats.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsm or .xlsx files.
- 3. Access Macro Tools: Navigate to the 'Tools' tab to easily access the Macro editor and recording features.
Frequently Asked Questions
Can I record VBA macros using the Automate tab?
No, the Automate tab is exclusively designed for recording and managing Office Scripts, which use TypeScript. To record VBA macros, you must use the Developer tab.
Why can't I see the Developer tab in Excel?
The Developer tab is hidden by default in Excel to simplify the interface for standard users. You must manually enable it through the Customize Ribbon settings in the File menu.
Are Office Scripts replacing VBA macros?
Office Scripts are Microsoft's modern automation solution primarily for Excel on the Web and cross-platform workflows. However, VBA macros are still fully supported in desktop versions of Excel.
Will my existing VBA macros run in Excel for the Web?
No, Excel for the Web does not support running or recording VBA macros. You need to use the desktop version of Excel or migrate your automation to Office Scripts for web compatibility.
