Creating and Inserting a Macro into a New Workbook

**brentjohn** · 06-06-2019, 08:51 AM

Greetings,
I am using "SaveCopyAs" to create a new Workbook. I would like to create and insert a macro into the "ThisWorkbook" for the new Workbook, to initialize when the new Workbook is opened. I do not want for the macro to be on the existing Workbook.

**CK76** · 06-06-2019, 08:59 AM

I'd not recommend doing that. As there are several issues associated.

Have a read of link.
http://www.cpearson.com/Excel/VBE.aspx

I'd recommend, including check to disable macro based on workbook name (or some other check), have it in the existing workbook and SaveCopyAs.

**brentjohn** · 06-06-2019, 10:01 AM

CK76,
Thank you much for the suggestion - it is working perfectly!!

Creating and Inserting a Macro into a New Workbook

LinkBack

Thread Tools

Rate This Thread

Display

Creating and Inserting a Macro into a New Workbook

Re: Creating and Inserting a Macro into a New Workbook

Re: Creating and Inserting a Macro into a New Workbook

Thread Information

Users Browsing this Thread

Similar Threads

Creating Macro using Active Workbook

Inserting a worksheet into another workbook loses its macro in the journey

Macro for copying & inserting a variable number of rows into a separate workbook

[SOLVED] Creating a macro to apply to another workbook

[SOLVED] Need a macro for creating payslip using auto vlookup and inserting and renaming sheet

Macro for inserting code into another workbook, to run when opened

creating new workbook macro

Bookmarks

Bookmarks

Posting Permissions