Features cannot be saved in macro-free workbooks

Asked By dannydevs 0 points N/A Posted on - 08/04/2011

Hello friends, I met an error while using Microsoft Excel. I am not be able to save my file, the error message tells me to save a file with these features, and then choose a macro-enabled file type in the File, see below the screen shot of the error for better view of my problem.

The following features cannot be saved in macro-free workbooks:

VB project

To save a file with these features, click No, and then choose a macro-enabled file type in the File Type list.

To continue saving as a macro-free workbook, click Yes.

Yes         No          Help

I checked on the Microsoft Excel, and enable it, but the problem is the error still persist, I tried rebooting my computer and after which I tried to do the same task, but still it cannot save my file, please help me with this post, thanks a lot.

• Status: Open
• Question Views: 8452
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by brandon_b

Go To Solution

Best Answer

Best Answer

Answered By brandon_b 0 points N/A #98182

Features cannot be saved in macro-free workbooks

That warning message is actually seen in Microsoft Excel 2007 when you try to use Microsoft Excel 97-2003 xls for compatibility.  You can prevent the warning from showing up it by following these steps:

1. At the upper left corner of the Excel window, click on the Office button.

2. On the pop-up window that will come up (bottom part), click on the “Excel Options” button.

3. From the left panel, find the “Trust Center” and select it.

4. Click on the “Trust Center Settings…” button.

5. From the left panel, select the “Macro Settings” and select it.

6. If you want to just enable all macros, you can select “Enable all Macros..” option

7. Click OK.

You can also try the other options to fit your preference but if you are going to just enable macros, make sure that the file you are trying to open is from a trusted source.

About brandon_b

Questions
0

Answers
5

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 08/05/2011
• Question Category: MS Excel

Answered By Carl Jack 10 points N/A #98183

Features cannot be saved in macro-free workbooks

Hallo Danny,

That is a security issue. You will therefore go to each of the system that will be ruining your application and then change the macro security as well as go into trusted sources and then check the box for access to the VB Project.

If you are using 2007 you will find it in the upper Right Option Icon. It is the one that displays the print as well as save options. At the bottom of it, you will need to go to the box button for Excel Options.

In the event that the security to low, then it just blocks the code to set it higher. You will therefore need to check Office help for a good step by step on how to do these security settings.

Regards,

Carl

About Carl Jack

Questions
1

Answers
1657

Best Answers
417

• Vote Up 0 Vote Down

• Posted on - 09/08/2012
• Question Category: MS Excel