If you want to save an *.xlsm file in the old *.xls format, you need to select the appropriate file type in the Save As dialog.

An Excel 97-2003 workbook will not use a different file extension for macro enabled files and all VBA in the file will be retained. Be aware that there may be loss of functionality if you use features in the newer file that the older version cannot interpret.

If you want to save an *.xlsm file in the old *.xls format, you need to select the appropriate file type in the Save As dialog.

An Excel 97-2003 workbook will not use a different file extension for macro enabled files and all VBA in the file will be retained. Be aware that there may be loss of functionality if you use features in the newer file that the older version cannot interpret.

Edit after you posted the screenshot:

the first warning is about data validation. The second one is something else, but most certainly not about VBA. Your VBA will make it into the .xls file and you'll need to run it to see if there are problems with the code. There are not many VBA command changes between these versions, so the code will probably run fine.