I don't currently know of any workaround for this other than avoiding the use of Mac Mail to send CSV attachments. If you turn on the Macro Recorder and save a sheet to PDF, it works as expected and writes out the ActiveWorkbook version to the code module. This is odd behavior and has the potential to break downstream software that consumes CSV files that were exported from Excel on a Mac and then emailed to users. Excel Mac 2011 VBA will always save all worksheets. I have some CSV import code that is failing to import files exported by Excel for Mac 2016.
