TMG Macro Recorder? Excel’s Built-In Option Explained

VBA & macros · Updated November 22, 2026

“TMG macro recorder” is not the name of a standard feature in Microsoft Excel. If you mean recording a macro in Excel, use the built-in Macro Recorder on the Developer tab; if TMG refers to a particular app or product, its full name or version is needed to identify the right recorder.

What does TMG mean here?

TMG is an acronym used by different products and communities, so the phrase alone does not point to one specific macro-recording tool. In genealogy, for example, TMG commonly means The Master Genealogist. In Excel, however, the feature for turning a sequence of spreadsheet actions into reusable code is called the Macro Recorder, not the TMG Macro Recorder.

This distinction matters when looking for instructions or downloads. A tutorial for Excel’s recorder will not necessarily apply to a recorder built into a different program, and a third-party tool with TMG in its name may have its own features and safety considerations. Check the product’s full name, publisher, and version before installing anything. If the question is about automating work in an Excel workbook, the built-in recorder is the appropriate starting point.

What Excel’s Macro Recorder does

Excel’s Macro Recorder observes supported actions you perform and translates them into Visual Basic for Applications (VBA) instructions. You can then run the saved macro to repeat those instructions. For instance, you could record selecting a range, applying a number format, adding a header, and adjusting column widths. Running the macro later repeats the recorded sequence.

The recorder is useful for routine, predictable tasks, but it does not understand your intention. If you record a procedure that formats rows 2 through 20, it will generally repeat those specific actions; it will not automatically know to include new rows added next month. It also does not normally capture every aspect of your interaction like a general desktop mouse-and-keyboard playback tool. It records supported Excel operations as VBA, which makes it most suitable for spreadsheet tasks.

How to record a macro in Excel for Windows

In Excel for Microsoft 365 on Windows, the Developer tab contains the recording controls. If it is not visible, enable it first using File > Options > Customize Ribbon, select the Developer check box in the main tabs list, and choose OK. Then follow these steps:

  1. Open the workbook where you want the macro, and decide which cells or data it should affect.
  2. Choose Developer > Record Macro.
  3. Enter a name. Use a name with no spaces, such as FormatMonthlyReport. You can also assign a shortcut key, select where to store the macro, and add a description.
  4. Carry out the spreadsheet actions you want recorded. Work deliberately: selecting the wrong cells or making an unnecessary change can become part of the macro.
  5. Choose Developer > Stop Recording when you are finished.
  6. Save the workbook in a macro-enabled format if you are storing the code in that workbook.

A shortcut assigned in the Record Macro dialog can make a macro faster to run, but choose one carefully: a shortcut may override a built-in Excel shortcut while the workbook is open. You can also run a saved macro from Developer > Macros, select its name, and choose Run. The Mac version has a Developer tab and a Record Macro command too; enable the tab through Excel > Preferences > Ribbon & Toolbar if it is hidden. Labels or dialog details can vary slightly between Mac and Windows.

Absolute and relative references

One recording setting has a large effect on whether a macro is reusable: Use Relative References. With relative references off, recorded actions often refer to fixed cells. If you record formatting cell B2, the resulting procedure may target B2 each time, even when your active cell is somewhere else. That can be suitable for a report with a permanent layout.

With relative references on, recorded actions are described in relation to the starting position. For example, if you begin at A1 and format the cell one column to the right, the macro can repeat that action relative to whichever cell is active when you run it. This is useful for applying the same operation to different parts of a sheet. Choose Developer > Use Relative References before recording, and check the setting before you begin. A common mistake is recording with the wrong reference mode and assuming the macro will adapt automatically.

Where macros are stored and how to keep them

The Record Macro dialog lets you choose a storage location. This Workbook keeps the macro with the current file, which is often best when the automation is specific to one workbook. Personal Macro Workbook stores macros in a hidden workbook that opens when you start Excel, making them available for use across your workbooks on that computer. New Workbook puts the macro in a separate workbook.

Excel workbooks containing VBA are commonly saved as Excel Macro-Enabled Workbook (.xlsm) files. Excel Binary Workbook (.xlsb) can also store VBA. A regular .xlsx workbook cannot preserve VBA macros: if Excel warns that the format does not support macros, saving as .xlsx removes the code. Keep the macro-enabled original when you need to retain the automation, and share it only with people who can safely use the macro and understand its effect.

Personal Macro Workbook is convenient but can be confusing if you move to another computer: the macros are stored locally, not automatically embedded in every workbook you edit. If you depend on one, plan how to back it up or transfer it securely. A workbook-specific macro is easier to share as one file, but recipients still need to handle its code and macro security appropriately.

Inspecting and editing recorded VBA

A recorded macro is not locked away. Choose Developer > Visual Basic to open the VBA editor and inspect the generated code. On Windows, Alt+F11 is a common shortcut for opening the editor. On Mac, Option+F11 may work; some keyboards require Fn as well. The recorded instructions are usually in a module associated with the workbook or Personal Macro Workbook.

Reading the code helps diagnose actions that target the wrong range or repeat more than intended. For example, a short macro can make the current cell bold. Before running or modifying VBA, save a separate copy of the workbook: macros cannot be undone with Ctrl+Z, and a macro can change or delete data.

Sub BoldActiveCell()
    ' Store the selected cell so the formatting target is clear.
    Dim targetCell As Range
    Set targetCell = ActiveCell

    ' Apply bold formatting to that cell.
    targetCell.Font.Bold = True
End Sub

This example acts on whichever cell is active when it runs; it does not prompt for confirmation or decide whether the cell is appropriate. A recorded macro can be edited into a more flexible procedure, but adding conditions, loops, or choices requires VBA knowledge that the recorder does not supply on its own.

Safety and macro security

Macros can perform significant actions, including changing workbook contents, deleting data, and interacting with files. Only run a macro when you trust its source and understand why the workbook needs it. A file arriving by email or download is not safe merely because it looks like a spreadsheet. If a macro-enabled workbook is unexpected, ask the sender what the macro does rather than enabling it automatically.

Excel’s security controls may block or warn about macros, particularly in files from the internet. Do not solve that problem by enabling all macros globally. For work or school devices, follow your organization’s policy; administrators may control the available settings. If you need to inspect code, do so cautiously and ask a knowledgeable person when its purpose is unclear. A trusted file should still be checked for unexpected behavior if it comes from an unfamiliar source.

Limitations, alternatives, and common problems

The recorder is a practical starting point, not a complete automation system. It may generate repetitive VBA, rely on specific cell addresses, and fail when the worksheet layout changes. It will not automatically create robust logic for conditions such as “format every row where the status is overdue.” That kind of task usually needs editing the VBA to add logic, or choosing another Excel feature better suited to the job.

  • For repeatable formatting: a recorded macro can work well when the sheet structure stays consistent.
  • For recurring calculations: formulas, tables, or built-in Excel tools may be easier to maintain than a macro.
  • For cross-platform automation: Office Scripts may be an option in supported Microsoft 365 environments, but they are not VBA macros and have different capabilities.
  • For Excel in a browser: Excel for the web does not create or run VBA macros. Use desktop Excel for VBA recording and execution.

If nothing happens when you run a macro, check that the correct workbook is open, that you selected the intended macro, and that Excel has not blocked it under your organization’s security policy. If a macro runs but affects the wrong cells, investigate whether it was recorded with absolute or relative references and inspect the recorded code. If it disappears after saving, check that the file was saved as .xlsm or .xlsb rather than .xlsx.

Frequently Asked Questions

Is TMG Macro Recorder part of Excel?

No. Excel calls its built-in feature the Macro Recorder. TMG is an acronym used in other contexts, so a specific product called TMG would need to be identified by its full name and version.

Does Excel record my mouse movements?

Excel’s recorder translates supported spreadsheet actions into VBA; it is not simply a video or general mouse-movement playback. It can record operations such as selecting cells and changing formatting, but the result is Excel code rather than a recording of every movement.

Can I record macros in Excel for the web?

No. Excel for the web does not create or run VBA macros. Open the workbook in the Excel desktop app to use the VBA Macro Recorder. Office Scripts are a separate automation option in supported Microsoft 365 setups.

Why did my macro disappear after I saved?

The workbook may have been saved as .xlsx, which does not retain VBA code. Save a workbook that contains macros as .xlsm or .xlsb, and confirm the macro is stored in that workbook rather than only in a Personal Macro Workbook on another computer.

Can I undo a macro with Ctrl+Z?

No. Excel’s normal undo history does not reverse actions performed by a VBA macro. Save a separate copy before running unfamiliar code, especially if it changes or removes data.

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.