Exclamation mark on .xlsm file

xlsm
Pina Parmar picture Pina Parmar · Oct 30, 2015 · Viewed 19.7k times · Source

i've prepared one excel file with Visual Basic code. It was saved with .xlsm extension. And now the excel icon is appeared with exclamation mark that is irritative. Can I remove that exclamation mark from the icon?

Answer

Jenis Kasundra picture Jenis Kasundra · Oct 30, 2015

save that file with .xls extension.you can remove exclamation mark

With the introduction of Office 2007, Macro enabled worksheets saved as .XLSM files show the exclamation point as part of the icon. This is not to show that it is an error or that it is dangerous, only to inform you that it contains macros. “Feature” or not well thought out placement of punctuation? It’s completely normal, and everything is fine as long as you trust the document and/or created the document and macros yourself.

Related questions

When should the xlsm or xlsb formats be used?

Since Excel 2007, Microsoft has split the classical .xls format to several formats (in particular, .xlsx, .xlsm, .xlsb). I've got no problem to understand the use and purpose of .xlsx format but I am still wondering whether we should use a .…

Read More
paste special values in vba

I am working on a small project which requires me to copy and paste certain columns if I detect "true" in the row. I am trying to paste these selected columns onto a different sheet and I want to paste …

Read More
How to save XLSM file with Macro, using openpyxl

I have .xlsm file with a Macro function. I'm loading it using openpyxl and write some data to the file and finally want to save as a different .xlsm file. To save the file as XLSM file I have used …

Read More