VBA module names

[2077delta]

Is there a way to rename the VBA in Excel modules to something other than module1, module2 etc. I have tried exporting them to a different name and reimporting them, but the imported version still comes back with the same module name before I exported it.

 

[Jack in the UK]

OF cause use the VBE and rename in the viewer.. can only be one word thou so Jack_in_the_UK is fine

Jack in the UK will fault...

 

[Tom Urtis]

Adding to what Jack said, while in the Project Explorer of the Visual Basic Editor, select your module name (Module1 or whatever), then click on View > Properties Window (or hit F4) and you will see that module (Module1 for example) in the first field. Double click or otherwise hilite that Module1 name and type in your desired name, and close out the Properties Window, or the VBE altogether.

 

[2077delta]

Thanks guys!