| Every time I try to save an xlsm, edit a CVS or 2003-2007 Excel file version it gives a warning that it will be saved in compatibility mode. |
| I have this habit of saving Excel work every now and then via Ctrl+S and Window keeps popping up the compatibility warning. |
|
How can I disable this annoying 'Compatibility mode pop-up using a macro module
eg Sub FileSave() ActiveWorkbook.SaveAs Filename:="D: & ActiveSheet.Name & ".xls", FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ End Sub It cause pop up warning ...
|
Hi David,
I assume you are using a version of Excel that supports the xlsx format. If so, why are you saving files as .xls?
I don't know any way to turn off the annoying warning when saving CSV files in 2013, that drives me nuts too. O365 doesn't do this though, or at least you can turn it off.
Regards
Phil
Thanks Philip the advice.
The point is I want to keep the macro module in the Excel file for some one use; but if in xlsx format, macro module will be lost unless switch to xlsm, or xls format
but not so sure the following code do the work
Sub FileSave()
ActiveWorkbook.SaveAs Filename:="D: & ActiveSheet.Name & ".xlsm", FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
Application.DisplayAlerts = Flase
ActiveWorkbook.Close
End Sub
Pls comment !
I'm confused. So you want to save macros, but you don't want to use the .xlsm format? If you have VBA in a file and save it as .xlsx the VBA will be removed.
If you save it as the older .xls you'll get the compatibility warning.
Phil
OK , noted tks the clarifications.
