CODEWITHSUNDEEP
excelvba
CodeCatia
CodeCatia

Reputation: 127

How can Record Macro create code in New Module instead of Sub

I'm using "Record Macro" function in Excel 2010. In VB Editor generated code is placed in Sub Macro1() inside "Module1". Every next record is placed in "Module1" under Sub Macro2().

How can I get new generated code in new "Module2" instead of "Module1" or new Workbook?

Thank you

Upvotes: 1

Views: 1175

Answers (1)

Mark Fitzgerald
Mark Fitzgerald

Reputation: 3068

Save and close the workbook, then re-open it.

The next time you use Record Macro, it will default to Module2.

Upvotes: 1

Related Questions