VBA to save a copy of .xlsm workbook as .xlsx

Hello all,

I wondering if anyone can help me, I have a workbook with 2 sheets. I have created a userform and have several macros. My question is this, is there a way to save a copy of this workbook in .xlsx format removing all the macros and vba? I would like to execute this from a command button on my userform.

So I would press the button and it would ask like normal where I would like to save a copy to, with the exception that I want to save it as a non macro file format.

Thank you...

You can browse then save the file as .xlsx (macro free) and suppress the alerts

Please Login or Register  to view this content.

Hope this helps