{"id":703,"date":"2018-06-28T14:17:10","date_gmt":"2018-06-28T14:17:10","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=703"},"modified":"2024-03-14T12:58:56","modified_gmt":"2024-03-14T12:58:56","slug":"the-macro-recorder","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/","title":{"rendered":"The Macro Recorder"},"content":{"rendered":"\n

A popular method to create a macro is to use the Macro Recorder<\/strong>. When you use this tool, you show Excel (by clicking on different elements in the application) the sequence of steps that it needs to perform each time you execute the macro.<\/p>\n\n\n\n

Excel records every move you make, including actions such as scrolling, clicking cells, and so on. You should have your moves planned in advance when you record a macro, otherwise, you will have a lot of unwanted code.<\/p>\n\n\n\n

Recording a Macro<\/h2>\n\n\n\n

You can record the macro in one of two ways:<\/p>\n\n\n\n

    \n
  1. In the first method, click the button in the lower-left corner of the worksheet.<\/li>\n<\/ol>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    If you don\u2019t see this icon, right-click the green area and make sure that the Macro Recording<\/strong> position is checked.<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n
      \n
    1.  Another method is to choose VIEW >> Macros >> Macros >> Record Macro…<\/strong>.<\/li>\n<\/ol>\n\n\n\n

      When you use one of these methods, a new window will appear.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n
      \n

      When you create a keyboard shortcut to your macro, you may want to consider using the Ctrl + Shift + letter <\/strong>because many keyboard shortcuts with only the Ctrl<\/strong> key are already taken.<\/p>\nTIP<\/cite><\/blockquote>\n\n\n\n

      Here, you can change the macro name and add a description. You can also create a shortcut key, so you will be able to execute your macro instantly.<\/p>\n\n\n\n

      \n

      If you choose the shortcut that is already used in Windows, it will override the default one. For example, if you use the Ctrl + N<\/strong> shortcut for your macro, this shortcut will only be used to execute this macro, unless you change it in VIEW >> Macros >> Macros >> View Macros >> Options ….<\/strong><\/p>\nCAUTION<\/cite><\/blockquote>\n\n\n\n

      Look at the following example:<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      At first, it may seem that all cells, instead of D4<\/strong> are numbers. But when you use the Ctrl + `<\/span><\/strong> shortcut, you will notice that in fact only some of them are numbers, other are text and formulas.<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Let\u2019s suppose that you want to create a macro that will apply to each type of data<\/a> (numbers, text, and formulas) in a different color.<\/p>\n\n\n\n

      Because the macro recorder records your every move, you don\u2019t want to remember moves that are not necessary. In this example we will work with the HOME tab, so make sure that you have this tab already opened.<\/p>\n\n\n\n

        \n
      1. Click the record button, name your macro and apply a keyboard shortcut. Then choose HOME >> Editing >> Find & Select >> Go To Special<\/a><\/strong> and<\/a> select Constants >> Numbers<\/strong>.<\/li>\n<\/ol>\n\n\n\n
        \"\"<\/figure>\n\n\n\n

        After you click the OK<\/strong> button all the numbers become selected.<\/p>\n\n\n\n

        \"\"<\/figure>\n\n\n\n

        Select HOME >> Font >> Fill Color<\/strong> and choose the yellow color. Click outside the box to unselect cells.<\/p>\n\n\n\n

          \n
        1. Click Go To Special<\/strong> and this time select Constants >> Text<\/strong>. Select a green color and click any cell outside the area.<\/li>\n\n\n\n
        2. One more time choose to Go To Special<\/strong>, select Formulas,<\/strong> and check numbers. Click OK<\/strong> and apply the blue color.<\/li>\n<\/ol>\n\n\n\n

          Click the Stop<\/strong> icon to stop recording the macro.<\/p>\n\n\n\n

          \"\"<\/figure>\n\n\n\n

          If you did everything correctly, you should see the following result.<\/p>\n\n\n\n

          \"\"<\/figure>\n\n\n\n

          Executing the macro<\/h2>\n\n\n\n

          Click a blank cell and select Format Painter (HOME >> Clipboard >> Format Painter<\/strong>). Select all highlighted cells to remove formatting and align them to the right.<\/p>\n\n\n\n

          Now, execute the macro using one of the three methods:<\/p>\n\n\n\n

            \n
          1. Go to VIEW >> Macros >> Macros >> View Macros<\/strong>. Select the macro and click the Run<\/strong> button.<\/li>\n\n\n\n
          2. Use the shortcut key (if you defined it in the Record Macro<\/strong> window).<\/li>\n\n\n\n
          3. Go to DEVELOPER >> Code >> Macros<\/strong>.<\/li>\n<\/ol>\n\n\n\n

            As you can see with this macro all the highlighting can be done with just a single click.<\/p>\n\n\n\n

            Analyzing the Macro code<\/h2>\n\n\n\n

            In order to preview the code generated by the macro, use the Alt + F11<\/span><\/strong> keyboard shortcut.<\/p>\n\n\n\n

            Sub HighlightCells()\n'\n' HighlightCells Macro\n'\n' Keyboard Shortcut: Ctrl+Shift+Z\n'\n    Selection.SpecialCells(xlCellTypeConstants, 1).Select\n    With Selection.Interior\n        .Pattern = xlSolid\n        .PatternColorIndex = xlAutomatic\n        .Color = 65535\n        .TintAndShade = 0\n        .PatternTintAndShade = 0\n    End With\n    Range(\"G8\").Select\n    Selection.SpecialCells(xlCellTypeConstants, 2).Select\n    With Selection.Interior\n        .Pattern = xlSolid\n        .PatternColorIndex = xlAutomatic\n        .Color = 5287936\n        .TintAndShade = 0\n        .PatternTintAndShade = 0\n    End With\n    Range(\"F7\").Select\n    Selection.SpecialCells(xlCellTypeFormulas, 1).Select\n    With Selection.Interior\n        .Pattern = xlSolid\n        .PatternColorIndex = xlAutomatic\n        .Color = 12611584\n        .TintAndShade = 0\n        .PatternTintAndShade = 0\n    End With\n    Range(\"G4\").Select\nEnd Sub<\/pre>\n\n\n\n
            Lines 1, 34.<\/strong><\/p>\n\n\n\n
            Opening and closing of the subroutine.<\/p>\n\n\n\n
            Lines 2-6.<\/strong><\/p>\n\n\n\n
            These lines are comments<\/a>. Here, by default, you can find the name and the keyboard shortcut you assigned to the macro.<\/p>\n\n\n\n
            \n
            You cannot change the keyboard shortcut simply by changing the text in the comments, instead, you have to go to DEVELOPER >> Code >> Macros<\/strong>. Select the macro and choose Options.<\/strong> Change the shortcut key to the new one.<\/p>\nCAUTION<\/cite><\/blockquote>\n\n\n\n
            \"\"<\/figure>\n\n\n\n
            Lines 7, 16,<\/strong> and 25. <\/strong><\/p>\n\n\n\n
            This code was created when you chose HOME >> Editing Find & Select >> Go To Special …<\/strong> three times, selecting constants numbers<\/a>, constants text, and formulas numbers.<\/p>\n\n\n\n
            Lines 8-14. <\/strong><\/p>\n\n\n\n
            The With<\/strong> instructions will simplify your code. It allows you to refer to the object without the need for repeating the Selection.Interior<\/em> part each time. If you don\u2019t want to use the With<\/strong> keyword you can use the following code:<\/p>\n\n\n\n
            Selection.Interior.Pattern = xlSolid\nSelection.Interior.PatternColorIndex = xlAutomatic\nSelection.Interior.Color = 65535\nSelection.Interior.TintAndShade = 0\nSelection.Interior.PatternTintAndShade = 0<\/pre>\n\n\n\n
            Lines 9, 18, 27. <\/strong><\/p>\n\n\n\n
            Here, you apply the instructions saying that the cells are to be filled<\/a> with a solid color.<\/p>\n\n\n\n
            Lines 10, 19, 28. <\/strong><\/p>\n\n\n\n
            .PatternColorIndex = xlAutomatic<\/em> means, that for the selected cells there is a specified automatic pattern to draw objects and fill cells.<\/p>\n\n\n\n
            Line 11. <\/strong><\/p>\n\n\n\n
            When you chose the yellow color, Excel automatically created this line of code: .Color = 65535<\/em>. That\u2019s the index number of yellow color. You can also specify the yellow color by using: .Color = RGB(255,255,0)<\/em> or .Color = vbYellow<\/em>.<\/p>\n\n\n\n
            Lines 12, 13. <\/strong><\/p>\n\n\n\n
            For the following properties,<\/p>\n\n\n\n
            .TintAndShade = 0\n.PatternTintAndShade = 0<\/pre>\n\n\n\n
            you can assign a number between -1 (darkest) and 1 (lightest).<\/p>\n\n\n\n
            We don\u2019t want any tint and shade, so set them to 0, which is neutral.<\/p>\n\n\n\n
            Lines 15, 24, 33. <\/strong><\/p>\n\n\n\n
            In VBA, you can\u2019t select particular cells, only ranges. Range(“G8”).Select<\/em> means that Excel selects range G8, which is the same as cell G8. You can choose any cell, not necessarily those selected in the code. This code is used only to deselect the cells which you selected before applying colors.<\/p>\n\n\n\n
            \n
            You can select only one cell, even in searched cells. Remember not to select multiple cells<\/a>. If you do this, Excel will start looking only inside the selected range and not at the entire worksheet.<\/p>\nCAUTION<\/cite><\/blockquote>\n\n\n\n
            Absolute and Relative recording<\/h2>\n\n\n\n
            By default, Excel records a macro with absolute references to cells. But sometimes you may want to create relative cell references. Please keep reading to see how these two methods differ from each other.<\/p>\n\n\n\n
            Absolute Macro recording<\/h3>\n\n\n\n
            In order to record a macro in an absolute mode, follow these steps:<\/p>\n\n\n\n
              \n
            1. Go to DEVELOPER >> Code >> Record Macro<\/strong> and name it \u201eAbsolute\u201d. Click OK<\/strong> to start recording.<\/li>\n\n\n\n
            2. Select cell A1<\/strong> and type \u201eMon\u201d.<\/li>\n\n\n\n
            3. Select cell A2<\/strong> and type \u201eTue\u201d.<\/li>\n\n\n\n
            4. Select cell A3<\/strong> and type \u201eWed\u201d.<\/li>\n\n\n\n
            5. Click cell A1.<\/strong><\/li>\n\n\n\n
            6. Click Stop Recording<\/strong>.<\/li>\n<\/ol>\n\n\n\n
              Let\u2019s take a look at the generated code:<\/p>\n\n\n\n
              Sub Absolute()\n'\n' Absolute Macro\n'\n    Range(\"A1\").Select\n    ActiveCell.FormulaR1C1 = \"Mon\"\n    Range(\"A2\").Select\n    ActiveCell.FormulaR1C1 = \"Tue\"\n    Range(\"A3\").Select\nActiveCell.FormulaR1C1 = \"Wed\"\nRange(\"A1\").Select\nEnd Sub<\/pre>\n\n\n\n
              You can select any cell, but when you execute this macro you will always get \u201eMon\u201d in cell A1,<\/strong> \u201eTue\u201d in cell A2,<\/strong> and \u201eWed\u201d in cell A3.<\/strong><\/p>\n\n\n\n
              Relative Macro recording<\/h3>\n\n\n\n
              Let\u2019s see how the relative macro recording works.<\/p>\n\n\n\n
                \n
              1. Activate any cell.<\/li>\n\n\n\n
              2. Make sure that DEVELOPER >> Code >> Use Relative References<\/strong> is highlighted.<\/li>\n\n\n\n
              3. Go to DEVELOPER >> Code >> Record Macro<\/strong> and name it \u201eRelative\u201d. Click OK to start recording.<\/li>\n\n\n\n
              4. Type \u201eMon\u201d.<\/li>\n\n\n\n
              5. Select the cell below and type \u201eTue\u201d.<\/li>\n\n\n\n
              6. Select the cell below and type \u201eWed\u201d.<\/li>\n\n\n\n
              7. Click the cell where you typed \u201eMon\u201d.<\/li>\n\n\n\n
              8. Click Stop Recording<\/strong>.<\/li>\n<\/ol>\n\n\n\n
                This is the code generated by VBA:<\/p>\n\n\n\n
                Sub Relative()\n'\n' Relative Macro\n'\n    ActiveCell.FormulaR1C1 = \"Mon\"\n    ActiveCell.Offset(1, 0).Range(\"A1\").Select\n    ActiveCell.FormulaR1C1 = \"Tue\"\n    ActiveCell.Offset(1, 0).Range(\"A1\").Select\n    ActiveCell.FormulaR1C1 = \"Wed\"\n    ActiveCell.Offset(-2, 0).Range(\"A1\").Select\nEnd Sub<\/pre>\n\n\n\n
                Line 5.<\/strong><\/p>\n\n\n\n
                If you execute this macro in cell C5<\/strong>, Excel will insert \u201eMon\u201d inside the active cell (C5).<\/strong><\/p>\n\n\n\n
                Line 6.<\/strong><\/p>\n\n\n\n
                VBA moves the active cell one position below- to cell C6.<\/strong><\/p>\n\n\n\n
                Lines 10. <\/strong><\/p>\n\n\n\n
                The active cell is moved up by two cells, to cell C5.<\/strong><\/p>\n\n\n\n
                \n
                If you didn\u2019t start with cell A1 as a reference, it may seem strange that Excel generated such code. This is just the way that the macro recorder works.<\/p>\nNOTICE<\/cite><\/blockquote>\n\n\n\n
                Excel 365 Update<\/h2>\n\n\n\n
                  \n
                • Limited Visual Update:<\/strong> While the core functionality remains similar, Excel 365 offers a slightly modernized look<\/strong> for the Macro Recorder interface.<\/li>\n\n\n\n
                • Recording Still Straightforward:<\/strong> The process of recording macros hasn’t changed significantly. Users familiar with Excel 2016 can easily transition to recording macros in Excel 365.<\/li>\n\n\n\n
                • Security Enhancements:<\/strong> Excel 365 implements stricter security measures around macros. Macro settings might need to be adjusted to allow the running of recorded macros compared to Excel 2016.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
                  A popular method to create a macro is to use the Macro Recorder. When you use this tool, you show Excel (by clicking on…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[188],"yoast_head":"\nThe Macro Recorder<\/title>\n<meta name=\"description\" content=\"Learn how to create macros in Excel using the Macro Recorder tool. Record your actions and automate the sequence of steps to save time and improve efficiency.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Macro Recorder\" \/>\n<meta property=\"og:description\" content=\"Learn how to create macros in Excel using the Macro Recorder tool. Record your actions and automate the sequence of steps to save time and improve efficiency.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-28T14:17:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-14T12:58:56+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/macro-recorder-status-bar.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"The Macro Recorder\",\"datePublished\":\"2018-06-28T14:17:10+00:00\",\"dateModified\":\"2024-03-14T12:58:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/\"},\"wordCount\":1448,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/macro-recorder-status-bar.png\",\"keywords\":[\"added\"],\"articleSection\":[\"training\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/\",\"url\":\"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/\",\"name\":\"The Macro Recorder\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/macro-recorder-status-bar.png\",\"datePublished\":\"2018-06-28T14:17:10+00:00\",\"dateModified\":\"2024-03-14T12:58:56+00:00\",\"description\":\"Learn how to create macros in Excel using the Macro Recorder tool. Record your actions and automate the sequence of steps to save time and improve efficiency.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/macro-recorder-status-bar.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/macro-recorder-status-bar.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Macro Recorder\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The Macro Recorder","description":"Learn how to create macros in Excel using the Macro Recorder tool. Record your actions and automate the sequence of steps to save time and improve efficiency.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/","og_locale":"en_US","og_type":"article","og_title":"The Macro Recorder","og_description":"Learn how to create macros in Excel using the Macro Recorder tool. Record your actions and automate the sequence of steps to save time and improve efficiency.","og_url":"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/","article_published_time":"2018-06-28T14:17:10+00:00","article_modified_time":"2024-03-14T12:58:56+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/macro-recorder-status-bar.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"The Macro Recorder","datePublished":"2018-06-28T14:17:10+00:00","dateModified":"2024-03-14T12:58:56+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/"},"wordCount":1448,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/macro-recorder-status-bar.png","keywords":["added"],"articleSection":["training"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/","url":"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/","name":"The Macro Recorder","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/macro-recorder-status-bar.png","datePublished":"2018-06-28T14:17:10+00:00","dateModified":"2024-03-14T12:58:56+00:00","description":"Learn how to create macros in Excel using the Macro Recorder tool. Record your actions and automate the sequence of steps to save time and improve efficiency.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/macro-recorder-status-bar.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/macro-recorder-status-bar.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/training\/the-macro-recorder\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"The Macro Recorder"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/703"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=703"}],"version-history":[{"count":10,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/703\/revisions"}],"predecessor-version":[{"id":17215,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/703\/revisions\/17215"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=703"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=703"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}