Go into the VBE
hit ctrl-r to view the project explorer
Select & expand your project in the project explorer
Hit F4 to see each the properties window

Select a module
rename it
Don't duplicate the name of any procedure or function or workbook name or
built-in function/property.

If you hit ctrl-f (to find), you can specify the current project.

Andy wrote:

Hi

Bit of a beginner here! I have a lot of modules in my personal workbook,
mostly set up by recording macros and then tweaking them.
My problem is that I've added and tweaked etc and now I have 19 modules -
called module 1 to module 19. The macros I use are scattered throughout
these, and I don't know which one does which bit without checking each one
individually. Is there any way of renaming modules or finding a certain
routine (say 'FixRightMinus') rather than looking at each module? I realise
it's probably a macro-management thing and I shouldn't have got into a bad
habit months ago!
Thanks.

--

Dave Peterson