LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 905
Default How to reorder/rename modules?

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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rename Modules Joe K. Excel Programming 1 November 9th 07 03:05 PM
Need Code to rename standard modules davidm Excel Programming 5 March 27th 06 11:36 AM
Need Code to rename standard modules davidm Excel Programming 0 March 27th 06 04:26 AM
How can we rename modules? StargateFanFromWork[_3_] Excel Programming 4 January 26th 06 07:41 PM
Rename Modules Ian Excel Programming 6 March 29th 05 02:29 PM


All times are GMT +1. The time now is 04:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"