Macro to export individual sheets as template with embedded macro

[Macroidiot23]

Is there a way to export specific sheets (with macro) of a excel template to individual excel
templates together with the embedded macro ?

 

[Marc L]

Yes like you can see just activating the Macro Recorder and operating manually …​

​

 

[Macroidiot23]

Yes like you can see just activating the Macro Recorder and operating manually …​

​

I don’t understand what you mean, I hv a macro to my template that consists of many sheets. I want to export one of the sheets (with macro) to an individual excel template with macro. Is that possible?

 

[Marc L]

Yes directly if the VBA procedure is obviously located within the worksheet module.​

If not, save the workbook as a template after removing all the undesired worksheets.​

Whatever the case, you can follow post #2 …​

​