Macro Recording: change module

[yxz152830]

Maesters,
I have 4 modules in an excel file. I planned to use module 4 for testing different macros but macros always go to module 2 and I cannot find a way to change this. Any suggestions? Thanks!

 

[jasonb75]

I cannot find a way to change this.

There isn't a way to change it. Module 2 would have been created by the first recorded macro, it then becomes the default for all recorded macros in that workbook.

You might be able to work around it by renaming Module 4 as Temp, then renaming Module 2 as Module 4, and finally Temp as Module 2.