PDA

View Full Version : [SOLVED] My scripts are stored in different modules



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.

Bob Phillips
06-01-2011, 01:16 PM
No, you have to mange it yourself.

Paul_Hossler
06-01-2011, 04:09 PM
Another approach would be to rename 'Module1' as something more meaningful.

I find it makes it easier to find the Sub or function I'm looking for if I have related subs, etc. grouped onto a logically named module

Paul

Paul