Enable macro security

[sampath]

Hello,

Can not save macro excel. While saving that excel, warning message will appear. That warning message screen shot was attached here.

Regards,
Sampath.S

 

[Nebu]

Click on "NO" and proceed to save the file as macro enabled workbook.

Thanks

 

[sampath]

Hi Nebu,

When using your given option. same message will appear after save that file.

Note: In this workbook, Using 3 macro.

Regards,
Sampath.S

 

[Nebu]

You have to select the macro enabled workbook from the save as type drop down. The error is happening because you are trying to save your file in xlsx format. If the file is having macros the file extension should be xlsm.

here is the link http://www.dummies.com/how-to/content/saving-and-using-an-excel-2010-macroenabled-workbo.html

which explains step-by-step how to save a macro-enabled workbook

Thanks

 

[Khalid NGO]

Hi,
Further to what Nebu explained:

Select Excel Macro-Enabled Workbook from Save as type drop down.

Regards,

 

[vrunda]

While saving workbook ,in save as type select Excel-macro enabled workbook, & its extension is .xlsm in office 2007 & above versions.