Saving the file with an embedded macro

This recipe will show you how to save a file with an embedded macro. You might think that saving a file cannot be that difficult, and it isn't. The point is a normal Excel file will not allow you to save the macro you've just recorded, at least not with the normal file extension.

Getting ready

With 02_RecordMacro.xlsx still open, close the VBA Editor.

How to do it…

Now, proceed with the following steps:

1. In Excel, click on the Save button. The following message box appears:

   Figure 1.20 – Message box warning

2. Since we want to save the file together with the newly recorded macro, click No.
3. Select the folder where you want to save the file in the Save As dialog box.
4. At the bottom, below the File name textbox, to the right of the Save as type textbox, click on the arrow. From the list of options, select the second one from the top, Excel Macro-Enabled Workbook (*.xlsm):

   Figure 1.21 – Choosing...