Save a Workbook with Macros : Macro « Macro ActiveX Add in « Microsoft Office Excel 2007 Tutorial





Click the Office button, and then click Save As.
Click the Office button, and then click Save As.
Type a workbook file name.
           Click the Save as type list arrow, and then select:
           Excel Macro-Enabled Workbook. A workbook (.xlsm) that contains VBA code.
           or Excel Macro-Enabled Template. A template (.xltm) that includes preapproved macros.
Excel Macro-Enabled Template. A template (.xltm) that includes preapproved macros.
Click Save.
Click Save.










11.1.Macro
11.1.1.Create a MacroCreate a Macro
11.1.2.Assign a Macro to a ToolbarAssign a Macro to a Toolbar
11.1.3.Run a MacroRun a Macro
11.1.4.Delete a MacroDelete a Macro
11.1.5.Debug a Macro Using Step ModeDebug a Macro Using Step Mode
11.1.6.Edit a MacroEdit a Macro
11.1.7.Record a MacroRecord a Macro
11.1.8.Save a Workbook with MacrosSave a Workbook with Macros
11.1.9.Open a Workbook with MacrosOpen a Workbook with Macros
11.1.10.Sign a Macro ProjectSign a Macro Project
11.1.11.Create a self-signing certificate for a macro projectCreate a self-signing certificate for a macro project
11.1.12.Change Macro Security SettingsChange Macro Security Settings