Excel Macro Recorder: Is It Available Without a License?

Excel’s Macro Recorder is built into the desktop app; it is not a separate add-on that needs its own license. However, recording macros requires a working desktop version of Excel with a valid license, and an unactivated or restricted installation may prevent you from editing or recording. Excel for the web does not record or run VBA macros, even if your account can use Excel online.

What “unlicensed” means for the Macro Recorder

If Excel displays “Unlicensed Product,” the message refers to activation of the Office app, not a missing Macro Recorder entitlement. The recorder is a feature of desktop Excel, so there is no separate recorder subscription or add-in to buy. What matters is whether the installed Excel app is activated under a license that includes desktop Excel and whether your organization allows the feature.

When Office cannot verify a license, the cause might be a subscription that ended, signing in with the wrong account, an expired work or school assignment, or an activation problem. Microsoft 365 Apps can enter reduced functionality mode when a subscription or license is no longer valid. In that state, you may be able to open and print files but be unable to create or edit them. Since recording requires Excel to make changes to a workbook, it will not be usable if editing is disabled.

A licensing message is only one possible reason the recorder is missing or unavailable. Excel for the web lacks VBA macro recording, and a company administrator can impose security or application policies. Identifying which situation applies is more useful than looking for a separate “macro recorder license.”

What the recorder does—and what it does not do

The recorder watches certain actions you perform in Excel and writes corresponding VBA instructions. For example, you can start recording, format a range, apply a number format, and stop recording. Excel saves those actions as a macro that can repeat the recorded sequence later. This can help automate repetitive, predictable work without requiring you to write every line of VBA yourself.

It does not turn every task into a flexible, intelligent automation. A recorded macro generally repeats the specific commands and references captured during recording. If you format cells D2:D20, the generated code may target that exact range rather than automatically finding a changing data set. The recorder may also produce lengthy code for a short series of actions, and you may need to edit the VBA or record a cleaner sequence to make it reusable.

The recorder captures supported Excel actions, not every possible action in Windows or every feature in Excel. It cannot infer what you intended, decide how to handle unexpected data, or reliably create general-purpose logic from a one-time workflow. For a process that needs conditions, loops, error handling, or decisions based on changing input, learning some VBA or choosing another automation tool may be more appropriate.

Where to find it in desktop Excel

In Excel for Microsoft 365 on Windows, you can start a recording from either of these locations:

View > Macros > Record Macro
Developer > Code > Record Macro

If the Developer tab is not visible, open File > Options > Customize Ribbon, select the Developer check box in the list of main tabs, and choose OK. Showing the tab does not require a separate license, although Excel still needs to be activated and able to edit the workbook.

Excel for Mac also includes VBA and a macro recorder in the desktop app, though menus and some VBA capabilities differ from Windows. Do not assume a Windows-specific macro will work unchanged on a Mac: code that calls Windows components, such as certain operating-system APIs, may not be portable. On either platform, save a backup before running a macro because Excel macros cannot be undone with Ctrl+Z. On Mac, use the corresponding Command-based shortcut where Excel shows one; Windows shortcuts do not always match.

Excel for the web is a different case

Excel for the web can open and edit many workbooks, including files that contain VBA, but it cannot create, run, or edit VBA macros. That limitation is about the web app’s capabilities, not proof that your account lacks a license. A workbook with existing VBA can still be useful for ordinary spreadsheet work in the browser, but its VBA code will not execute there.

If you need to record or run VBA, open the workbook in the desktop Excel app. In a browser, look for an option such as Open in Desktop App, if your account and device provide it. If you only have access to Excel for the web, consider Office Scripts for supported tasks instead; Office Scripts are a different automation system and are not recordings of VBA macros. Availability can depend on your Microsoft 365 plan, organization settings, and platform.

How to diagnose a missing or disabled recorder

Work through the checks below before changing macro security settings or reinstalling Excel:

Confirm which app is open. If it is Excel in a browser, VBA recording is not available there. Open the desktop app if you need a VBA macro.
Check activation. In Windows Excel, open File > Account and review the product information and signed-in account. If Excel reports an activation problem, use the offered activation or sign-in options and confirm that the account has a license for desktop Excel.
Check whether editing works. If Excel says the product is unlicensed or the file is read-only, resolve that restriction first. A read-only workbook, protected sheet, or organizational policy can also prevent particular changes even when Excel itself is activated.
Look for the Developer tab or use the View menu. The tab may simply be hidden. The View menu provides another route to Record Macro in desktop Excel.
Ask your organization’s administrator if needed. Work or school devices may have centrally managed activation, macro, or application policies. An administrator can tell you whether the restriction is intentional and what approved options are available.

Activation and macro security are separate checks. A valid license does not mean every macro is trusted, and enabling macros does not fix an unlicensed installation. Avoid downloads or instructions that promise to activate Office without authorization; they can put your account, files, and device at risk.

Saving and running a recorded macro

A workbook that contains VBA normally needs to be saved in a macro-enabled format, such as Excel Macro-Enabled Workbook (.xlsm). If you save a workbook containing macros as the standard .xlsx format, Excel warns that the VBA project will not be preserved in that file. Keep a separate copy if you need both a macro-free version and a macro-enabled version.

Before recording, decide whether the macro should use absolute or relative references. Absolute references target particular cells; relative references can make recorded actions apply in relation to the selected starting cell. The choice changes what happens when you run the macro from somewhere else, so test it on a copy and inspect the result. Give the macro a clear name and, if useful, a shortcut or description that will help you recognize it later.

Do not expect Ctrl+Z to reverse a macro after it runs. Most VBA macros clear Excel’s normal undo history, so an unintended change may require closing without saving or restoring a backup. A sensible workflow is to save a copy, test the macro on representative data, and only then use it on the working file.

Licensing, security, and trust

Macros can make changes beyond the visible formatting or data entry you recorded, especially if their VBA code has been edited or came from someone else. Treat an unfamiliar macro-enabled workbook with the same caution you would apply to other files from an untrusted source. Do not enable its content simply because Excel displays a warning or because a colleague says the file is safe; verify where it came from and what the code is intended to do.

Organizations may block macros or allow them only from approved sources. Those controls are not the same as an unlicensed product state, and users may not be able to change them on managed devices. Avoid setting Excel to enable all macros globally as a troubleshooting shortcut. If a trusted workplace file is blocked, ask the administrator about the approved way to access it rather than bypassing the policy.

When to use another automation option

The Macro Recorder is a practical starting point when you have desktop Excel, a repetitive sequence of supported actions, and a workflow that is stable. It is less suitable when the process must run in a browser, be shared across platforms, adapt to changing data, or connect to other services. The right tool depends on the job, not just on whether a recorder button is visible.

Use VBA macros for desktop Excel automation that benefits from VBA code or needs to work with a macro-enabled workbook.
Consider Office Scripts for supported cloud-based Excel automation, particularly workflows designed for Excel on the web. It is not interchangeable with VBA, and availability varies by account and administrator settings.
Use built-in Excel features such as tables, formulas, and Power Query when they solve the task more clearly than replaying a sequence of clicks. These options can be easier to maintain when the goal is data transformation or repeatable calculations.

If your only obstacle is the word “unlicensed,” first establish whether you are using the desktop app and whether that app is activated. If the license is valid but the recorder remains unavailable, check the interface, file permissions, and organization policies before assuming the feature requires an extra purchase.

Frequently Asked Questions

Is the Excel Macro Recorder free?
The recorder is included in desktop Excel rather than sold as a separate add-on. You still need a valid license for the desktop Excel app, and your organization may restrict macro use.

Can I record a macro with an unlicensed copy of Excel?
If Excel is in reduced functionality mode and does not allow editing, you cannot record a macro that changes a workbook. Resolve the activation or license issue through the account or organization that provides Excel.

Can Excel for the web record or run macros?
No. Excel for the web does not create, edit, or run VBA macros. Open the workbook in desktop Excel for VBA, or explore Office Scripts if they fit the task and are available to your account.

Why is Record Macro missing from the ribbon?
You may be using Excel for the web, the Developer tab may be hidden, or a policy or activation problem may be limiting features. In desktop Excel, check View > Macros and review File > Account on Windows.

Do I need to pay separately for VBA?
No separate VBA or Macro Recorder add-on is required. Access depends on having a licensed desktop version of Excel; the exact license and any organizational restrictions depend on how you receive Office.

Try it: the Column Letter to Number: aA is 27, XFD is 16,384. Converts both ways.

More in VBA & macros

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.