Here are a couple of references you can browse. The both indicate that you
can prettymuch do what you want as far as naming the standard modules.

http://www.cpearson.com/Excel/codemods.htm

http://www.aspfree.com/c/a/VB.NET/Pr...als-Using-VBA/


"Joe User" <joeu2004 wrote in message
...
As I developed and reorganized VBA code, I inserted new modules, which
were numbered sequentially, e.g. Module1, Module2, Module3.

In hindsight, I would like the modules in the order Module3, Module1,
Module2.

Then I would like to rename them in sequential order again; that is,
Module3 - Module1, Module1 - Module2, and Module2 - Module3.

Even better, I would like to give each module a more descriptive name.

How can I do that?

Of course, if I don't mind calling the modules 4, 5 and 6, I can simply
insert new modules, cut-and-paste the text appropriately, then remove
modules 1, 2 and 3.

Alternatively, in this case, the Excel worksheets have nothing useful.
(Their contents are created by the macros.) So I could simply create a
new workbook, insert modules 1, 2 and 3, then cut-and-paste the text from
one workbook into appropriate modules in the other.

But I wonder if I am overlooking the obvious and much more
straight-forward way to accomplish this.