Getting Started with Programming by Lentzer Rémy;

Author:Lentzer, Rémy;
Language: fra
Format: epub
Publisher: Editions Remylent
Published: 2021-06-23T18:36:17+00:00

Figure 3.5 : Ending a macro

3.1.3 The XLSM file type and the macro security

To develop macros with Excel, you must save the workbook with a specific XLSM format, i.e. a workbook that supports macros.

By default, when you save a workbook, the format type is XLSX. This format has existed since Excel 2007. For the previous compatible versions, the format is .XLS. If you develop macros in an XLSX workbook, Excel will ask you to save it in the correct format at the time of saving the file.

Generally speaking, macros are disabled for security reasons and you cannot create them without changing a particular parameter.

To enable the creation of a macro, click on the small yellow triangle (Macro Security) in the Developer menu. The Macros settings dialog box will appear.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.