Skip warning when save as xlsx when VB project present

[BarefootPaul]

I have a workbook with an ActiveX button that makes a copy of the activesheet and emails it. I figured out how to remove the button from the copied sheet and how to save it as xlsx instead of xlsm. However, how do I stop Excel from warning me that I am saving it in this format and my VB projects won't be saved?

Windows 7, Office 2010

Much thanks

 

[cstimart]

I have a workbook with an ActiveX button that makes a copy of the activesheet and emails it. I figured out how to remove the button from the copied sheet and how to save it as xlsx instead of xlsm. However, how do I stop Excel from warning me that I am saving it in this format and my VB projects won't be saved?

Windows 7, Office 2010

Much thanks

Application.DisplayAlerts = False

 

[BarefootPaul]

Thanks. I knew it must be something fairly simple.