Save as .xlsx and not as .xlsm with VBA code

**Blue_Wings** · 04-21-2010, 04:42 AM

Good morning ppl,

When i put some VBA code in my excel sheet and then save the document, it says that i have to save it with macros permission, .xlsm and then my excel document icon will stay with a yellow wxclamation point, is this normal?

I am asking this because when i see examples of sheet and excel documents with macros, VBA code they are just .xlsx and not .xlsm.

How can i change from .xlsm to .xlsx and keep my vba code?

Thanks

**parrynz** · 04-21-2010, 04:59 AM

Hi, why do you care whether the extension is .xlsm vs .xlsx? MS have specifically provided a separate file extension so it's obvious to users that these contain macros and so if you want to use VBA in workbooks your just going to have to get used to it. File extension differences along with Ribbon menus and other changes is the direction MS are going with their architecture. You will find Word and PowerPoint also has macro enabled file extensions versus standard files as well. The icon for the file extension is just that - a picture. Because it has an exclamation doesn't mean there's anything wrong with the file.

regards,
Graham

**teylyn** · 04-21-2010, 05:24 AM

when i see examples of sheet and excel documents with macros, VBA code they are just .xlsx and not .xlsm.

Where? Can you provide links to examples?

**Blue_Wings** · 04-22-2010, 04:17 AM

Originally Posted by teylyn

Where? Can you provide links to examples?

Well sorry, maybe i didnt explain very well, because i was talking about this file (TestGrey2.xls) that was made in excel version 2003 and i couldnt see the exclamation point that i was seeng in the 2007 version.

Another thing, since i was writing some code in my excel 2007 sheets, always that i save something in the sheet it opens a window saying something like this:

"Privacy Notice: This document contains macros, ActiveX controls, information on XML expansion pack or Web components. These may include personal information that can not be removed Across the Document Inspector."

Its possible to disable this window?

Best regards.

**parrynz** · 04-22-2010, 04:37 AM

Hi, within Windows each file extension, such as a PDF file, a movie file or a Word document has an associated icon that's used when you view it in My Computer or Windows Explorer. MS decided that to differentiate their different file extensions they would use different icons, so that's why your seeing a difference so it's nothing to worry about.

Macros within 2003 will work in 2007 but it's in compatibility mode so sometimes formatting and certain features aren't compatible so it's usually best to save as 2007 version if your using 2007.

To remove message see the topic "Errors When You Create an Excel Workbook Project Based on an Existing Workbook" at http://msdn.microsoft.com/en-us/library/h8c469ey.aspx

regards,
Graham