How do YOU organize the Excel projects?

  • Thread starter Thread starter art
  • Start date Start date
A

art

I am not a pro in the programming, but I wrote several macros/programs doing
various stuff over the years. Some of the rutines I use for future
reference. All of them are in the Module1, Module2.....Module35.
If I want to find some of the projects I have to go through 30 modules to
find the right one.
How do pros take care of it?
Thanks.
 
You may assign names to your modules. In the VB Editor, select the module
and choose View>Properties>select the name that says Module1 and change it
as desired.
 
Back
Top