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.
No, you have to mange it yourself.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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
Posting Permissions
Reply With Quote
