Arrange modules in serial order in vba

**mukeshbaviskar** · 07-14-2013, 07:29 PM

Good morning friends,
Please guide me how to arrange the modules in serial order in vba. There are 35 modules which I created different time and because of it the modules are not in a serial order. I don't want to disturb the macros while arranging the modules in serial order.

Thanking you in anticipation.

Mukesh

**shg** · 07-14-2013, 07:54 PM

In the Properties window, change the module names as you wish. They automatically sort in alphabetical order.

**mukeshbaviskar** · 07-14-2013, 08:09 PM

I did this but then the name of macro starts with a file name in macro list in view macro in view ribbon. It also didn't run automatically after opening the file as before renaming. If not arrange in serial order then there is no problem in function but only to arrange it in a serial order I asked you.

Thank you.

Mukesh

**JosephP** · 07-15-2013, 02:56 AM

you can only arrange them in alphabetical order. do not use the same name for the module as the routine(s) it contains as that will cause the sort of problem you mentioned