removing module1

[stunik94]

Hello,

I've made a checklist with a big save button with a macro behind it.
after clicking the save button it creates a new file with specific name. This new file should be as clean as possible, so without any buttons or macro's.
Is there any way i can put in a couple lines of code to remove the macro in the new file?

cheers!

 

[davesexcel]

Once saved as an .xlsx extension, the modules will be gone.

You can delete buttons first.

Sheets(1).Buttons.Delete

Once saved, you won't notice the modules gone until you close and open again.

 

[stunik94]

Once saved as an .xlsx extension, the modules will be gone.

You can delete buttons first.

Sheets(1).Buttons.Delete

Once saved, you won't notice the modules gone until you close and open again.

the easiest solution is the best! thanks!