JohnnyBravo
06-01-2011, 12:10 PM
Excel 2007 Pro.
I noticed that whenever I record a new macro, Excel will put the script in a new module. I already had module 1 containing a couple of scripts and would prefer to have them all stored in one location. Is there a way to adjust the VBE to stop creating new modules and store them in module 1?
Of course I know I can just copy & paste the code into module 1, but it gets to be a hassle whenever I record a new macro.
I noticed that whenever I record a new macro, Excel will put the script in a new module. I already had module 1 containing a couple of scripts and would prefer to have them all stored in one location. Is there a way to adjust the VBE to stop creating new modules and store them in module 1?
Of course I know I can just copy & paste the code into module 1, but it gets to be a hassle whenever I record a new macro.