Forum home » Delegate support and help forum » Microsoft Excel Training and help » Saving Macro in .xls file extension

Saving Macro in .xls file extension

ResolvedVersion 2003

Wed 7 Sep 2011, 13:48 Delegate Herman said...

Herman has attended:
Excel VBA Introduction course

Saving Macro in .xls file extension

When I save the Excel in .xls, the macro I wrote is gone. Thus, I have to save it as .xlsm.

Can I know how to save the macro in .xls without saving it as .xlsm?

Thu 8 Sep 2011, 21:11 Trainer Anthony said...

RE: Saving Macro in .xls file extension

Hi Herman, thanks for your query. The .xlsm file format was introduced by Microsoft in Excel 2007 to prevent macros accompanying standard .xls files and causing security risks. However, if you Save As the file in the 97-2003 file format you should find the macro remains intact.

If you need to access the macro but still keep Excel 2007 features intact, save it into the .xlsb file format.

Hope this helps,

Anthony

Thu 15 Sep 2011: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Change the Default Width of All Columns in Excel 2010

If you want to change the width of the columns in your Excel 2010 spreadsheet, making them either larger or smaller, here's how:

In the Cells group on the Home tab, click Format.

Hover over the section called Cell Size and a drop down list will appear, select Default Width from this list.

In the Standard Width dialog box, enter the size you want to set as the default width and click OK.

View all Excel hints and tips

Saving Macro in .xls file extension

Saving Macro in .xls file extension

RE: Saving Macro in .xls file extension

Excel articles

Excel tip:

Change the Default Width of All Columns in Excel 2010