VBA Code to Save Copy File without Macro Button and VBA Code on Copy?

Hi All,
Just wanted to know is it possible to run VBA save new copy of file without macro button and VBA Code?
My master copy is .xlsm format. After clicking the macro button on my master copy, it will become .xlsx file.

Can we or does VBA able to run a code without macro button and VBA Code on the new saved copy? Except the formula on all the cells remain unchanged.
Hope to get advise and guide from you guy

My current code as below, result from google and modify a little.

Please Login or Register  to view this content.

You don't need a button for that u can try using beforeclose macro.

Please Login or Register  to view this content.

Only one thing is if you save a copy as .xlsx then when you open the copy the macros won't work or I think you will get an error that will say that your sheet contains macros and so on...

Look like will be more troublesome on that way, no any other way? or just clear out the VBA code on new save file copy?

You wan't the copy saved with no macros inside the copy? just an ordinary workbook .xlsx?

Originally Posted by stojko89

You wan't the copy saved with no macros inside the copy? just an ordinary workbook .xlsx?

Yeah, want the newly auto saved copy to be normal .xlsx excel file with no vba code or/and macro.

I will need to change the "button1" to the exact name where i placed in the button box only? Rest of the code, remain unchanged?

ActiveSheet.Shapes.Range(Array("Button 1"))

And don't forget about .Delete at the end

I dont know what is my button name. How to know or see?

Click on the button and above Cell A1 the name will show in a small window or right click it

I placed it exactly the same as below,

Please Login or Register  to view this content.

Showing run time error 438

Your button is named o9 ?
I told you not to forget .Delete

try this:

Please Login or Register  to view this content.

Error too, 1004.

This works fine in your file for me:

Please Login or Register  to view this content.

Just change the NewFN back to your original path.

Got it now. thanks a lot man!