Noms Macro Recorder: What It Is and Excel Alternatives

VBA & macros · Updated November 11, 2026

If you mean Microsoft Excel, “Noms macro recorder” is not a standard Excel feature or a recognized Microsoft product name. Excel’s built-in tool is called Record Macro; “Noms” may refer to a separate utility or a misspelling, so a publisher or download link is needed to identify a particular program reliably.

What “Noms macro recorder” might mean

The phrase alone does not point to a clearly identifiable, widely documented macro recorder. It could be the name of a small third-party app, a product used within a particular game or workplace, or simply a typo. Those possibilities matter: a desktop recorder that captures mouse and keyboard input works differently from Excel’s recorder, which turns supported actions inside Excel into Visual Basic for Applications (VBA) code.

If you encountered the name on a download page, check the exact spelling, the publisher, the supported operating systems, and whether the software records keystrokes or creates application-specific scripts. Avoid installing a program based only on a short name or an unofficial download mirror. If your question is about automating spreadsheet tasks, Excel’s own recorder is the relevant starting point and does not require a separate Noms application.

What Excel’s macro recorder does

Excel’s recorder observes many actions you perform in the desktop app and writes corresponding VBA instructions into a macro. You can then run those instructions again, assign the macro to a button, or inspect and adapt its code in the Visual Basic Editor. For example, recording a routine that selects a report range, applies a number format, makes the headings bold, and adjusts column widths can save time when you repeat that same sequence.

The recorder is not a general-purpose video or mouse recorder. It does not capture everything that happens on your computer, and it does not automatically understand the purpose of your task. It records supported Excel operations. A recorded macro may replay a series of selections and formatting commands rather than infer that you mean “format whichever report is open.” This difference explains why a macro can work on the original sheet but fail or affect the wrong cells on a differently arranged sheet.

How to record a macro in Excel for Microsoft 365

In Excel for Microsoft 365 on Windows, use the Developer tab or the View tab. If Developer is not visible, enable it from File > Options > Customize Ribbon by checking Developer in the main tabs list. You can then record a basic macro as follows:

  1. Open the workbook and, if needed, save a copy for practice.
  2. Select Developer > Record Macro, or use View > Macros > Record Macro.
  3. In the dialog, give the macro a name that starts with a letter and contains no spaces. Optionally choose a shortcut key, a storage location, and a description.
  4. Choose where to store it. This Workbook keeps it with the current file; Personal Macro Workbook makes it available in Excel on that computer.
  5. Perform the spreadsheet actions you want to repeat, then choose Developer > Stop Recording or use the stop control on the status bar.
  6. Save the workbook in a macro-enabled format if the macro is stored in it. The usual format is Excel Macro-Enabled Workbook (*.xlsm).

On Mac, Excel also has a Developer tab and a Record Macro command, though ribbon and dialog details can vary by release. Excel for the web does not create, run, or edit VBA macros; use the desktop app for those tasks. A macro-enabled workbook can be opened in the web app, but its VBA code will not run there.

Absolute and relative references

A key setting changes what the recorder does with cell locations. With relative recording, actions are described in relation to the active cell. If you begin at A1 and move one cell down, the recorded action can mean “move down one row.” With the default absolute-style recording, the action may instead target a specific address such as A2. The distinction determines whether a macro follows the current selection or returns to the same recorded locations.

In Excel for Windows, the Use Relative References control is on Developer > Code. Turn it on before recording when the same operation should apply relative to whichever starting cell is active; turn it off when fixed worksheet positions are intended. Try both approaches on a disposable copy if the workflow is unfamiliar. The option does not make a macro automatically adapt to every changing table: it only changes how recorded cell references are expressed.

For example, a macro intended to format the next row beneath a selected heading may be more useful with relative references. A macro that always applies a particular title style to cell A1 is more naturally recorded against a fixed location. If a report grows or moves unpredictably, neither setting alone can identify the report boundaries; that usually requires more deliberate VBA or a different automation design.

What the recorder cannot do well

Recording is most useful for short, consistent procedures. It is less suitable when the task depends on decisions, changing data sizes, or actions outside Excel. The recorder does not automatically create a robust loop for every row, decide which records meet a condition, or handle unexpected dialogs intelligently. It may capture direct formatting and fixed selections but still need editing before it can safely handle a new workbook layout.

  • Changing ranges: If a report has a different number of rows each week, a macro that selects a fixed range may omit new records or include blanks.
  • Repeated use: A recorded action that inserts a row, clears cells, or sorts data may produce a different result each time. Consider what happens on a second run.
  • Selections and active sheets: Recorded commands can rely on which cell, worksheet, or workbook was active. Running the macro from another location can change the outcome.
  • Non-Excel actions: The Excel recorder is not designed to automate arbitrary actions in other desktop programs or to record every mouse movement across Windows.

These limitations do not make the recorder useless. They indicate when a recorded starting point should be reviewed in the VBA editor or replaced with a more suitable tool. For a routine that changes important source data, test the macro on a copy and compare the output with the expected result before using it on the live workbook.

Common problems and practical fixes

If a macro appears to have vanished, check its storage location first. A macro saved in This Workbook belongs to that file; it will not automatically appear in a different workbook. A macro stored in the Personal Macro Workbook is available on that computer when Excel loads the personal file, but it is not automatically included when you send a workbook to someone else.

If the macro does not run, confirm that the file is saved as .xlsm when it contains VBA, and check whether Excel has blocked macros because of security settings or the file’s source. Do not lower security settings just to make an unfamiliar file work. If a macro runs but affects the wrong cells, inspect its recorded selections and the workbook or worksheet it expects to be active. Recording again with a deliberate starting cell can clarify the intended behavior.

To inspect or change a macro in desktop Excel on Windows, use Developer > Macros, select the macro, and choose Edit to open the Visual Basic Editor. You can also open that editor with Alt+F11 on Windows. Mac keyboard shortcuts differ and can depend on the keyboard and macOS settings; use the Developer tab or the Excel menu if a shortcut is unavailable. A quick review can reveal hard-coded cell addresses or repeated selection steps, but changing VBA requires care because a small edit can alter what the macro does.

Safety, sharing, and saving

Macros can make changes to a workbook and may contain code that performs other actions. Treat a macro-enabled workbook from an unknown sender like executable content, not like a harmless formatting file. Only enable macros when you trust the source and have a reason to run them. Excel’s security prompts are a warning to assess the file, not an obstacle to dismiss automatically.

Before running a macro that edits or deletes data, save a separate copy. VBA macro actions generally cannot be reversed with Ctrl+Z, so the normal Undo history is not a dependable recovery plan. For a shared workflow, explain what the macro changes, where it is stored, and which Excel desktop version it requires. A workbook saved as .xlsx cannot retain VBA macros; use .xlsm for a workbook that needs to carry its VBA code.

Excel recorder versus other automation options

For a short sequence of repeated Excel actions, Record Macro is convenient because it produces a starting point without requiring you to write VBA from scratch. If you need conditional logic, loops, error handling, or dynamic handling of data, VBA may be a better fit after the recorded code is reviewed. If you need to automate a process across Microsoft 365 services, Power Automate may suit some workflows, but it is a different tool and is not simply a recorder for every desktop action.

For repeatable data imports and transformations, Power Query is often more appropriate than recording clicks. It is designed to describe steps for shaping data and refreshing the result, rather than replaying a sequence of selections. For automation that must click through several Windows applications, a dedicated desktop automation tool may be relevant; verify its publisher, permissions, compatibility, and security practices before installation. The best choice depends on whether the task is spreadsheet formatting, data transformation, workbook logic, or cross-application interaction.

Frequently Asked Questions

Is Noms macro recorder part of Excel?
No. Microsoft Excel’s built-in feature is called Record Macro. The phrase Noms macro recorder does not identify a standard Excel command, so a specific third-party program cannot be confirmed from the name alone.

How do I open the Excel macro recorder?
In desktop Excel for Microsoft 365 on Windows, choose Developer > Record Macro or View > Macros > Record Macro. If Developer is hidden, turn it on through File > Options > Customize Ribbon.

Can I record macros in Excel for the web?
No. Excel for the web does not record or run VBA macros. Open the workbook in the Excel desktop app to record, edit, or run a VBA macro.

Can I undo a macro with Ctrl+Z?
Usually not. Running a VBA macro clears or bypasses the ordinary Undo history, so save a separate copy before running one that changes data.

Do I need a macro recorder to automate Excel?
No. The recorder is an optional way to generate starter VBA for repeated actions. Depending on the task, Power Query, manually written VBA, or another automation tool may be a better fit.

Related

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.